<div class="Section1"><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">I am new to Postgresql and am trying to write a function which will do a search and return the first page of
resultsalong with the total number of matches. How can I make my function return a cursor AND a scalar – can I do the
scalaras an OUT param and then make the function explicitly RETURN a refcursor?</span></font><p class="MsoNormal"><font
face="TimesNew Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Surajit</span></font></div><table><tr><td bgcolor="#ffffff"><font
color="#000000"><pre>---------------------------------------------------------------------------------------------
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
distributionof this message or any of its attachments or the information contained in this e-mail, or the taking of any
actionbased on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately
byreturn e-mail and delete this message.
---------------------------------------------------------------------------------------------</pre></font></td></tr></table>