[SQL] function returning a cursor and a scalar

2009-07-12 Thread Surajit Bhattacharjee
I am new to Postgresql and am trying to write a function which will do a search and return the first page of results along with the total number of matches. How can I make my function return a cursor AND a scalar - can I do the scalar as an OUT param and then make the function explicitly RETURN a r

Re: [SQL] function returning a cursor and a scalar

2009-07-14 Thread Surajit Bhattacharjee
n the query that actually gets the data. I google'd some and couldn't find a way to avoid two queries. Best Regards, Surajit Bhattacharjee __ Mobile: 508-277-9091 VOIP: 9032 -Original Message- From: Alvaro Herrera [mailto:alvhe...@commandprompt.com] Sent: Monday,