From: Surajit Bhattacharjee <surajitb@virtusa.com>
To: pgsql-sql@postgresql.org
Subject: function returning a cursor and a scalar
Date: Sun, 12 Jul 2009 23:07:15 -0400
Message-ID: <75F63F40B35C3144854E90019EB086770DDC0229@ws-mailsvr.Virtusa.com> (raw)
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.
---------------------------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: surajitb@virtusa.com
Subject: Re: function returning a cursor and a scalar
In-Reply-To: <75F63F40B35C3144854E90019EB086770DDC0229@ws-mailsvr.Virtusa.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox