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 refcursor?
Surajit --------------------------------------------------------------------------------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ---------------------------------------------------------------------------------------------
