On 02/20/2010 06:54 PM, Raymond O'Donnell wrote:
On 20/02/2010 13:08, Nilesh Govindarajan wrote:
On 02/20/2010 02:32 PM, John R Pierce wrote:
Nilesh Govindarajan wrote:
How do I create a procedure using plpgsql cursors to print the output
of the query in the cursor (using for loop) ?
In all docs I found, it seems to be a must to return data to the call
which is not what I want.
what is it going to print it on? the postgres server processes have no
console or stdout device.
Okay, so how do I print it to stdout ?
Well, it still has to get back to the client from the server - hence you
need to return the data.... stout here will be stdout of the server, not
the client.
Maybe if you say more clearly what it is you *do* want, rather than what
you don't, people may be able to help you. :-)
Ray.
Okay here's my query -
select c.cid, c.subject, n.title from comments c, node n where c.nid =
n.nid and c.status != 0;
This is the query to check list of comments requiring admin approval and
also the article titles on which this is posted.
I want to see this result on the screen at psql prompt. Since it may
return multiple rows, a cursor has to be employed here.
Now if I employ a cursor here in the function/procedure, how to see the
results ?
--
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
