Nilesh Govindarajan wrote on 20.02.2010 14:28:
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.
Hmm, I don't understand your question. When you run the query, psql will display the result... Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
