From: Craig Ringer [mailto:ring...@ringerc.id.au] Sent: Friday, August 24, 2012 6:59 PM On 08/24/2012 12:42 PM, Amit Kapila wrote:
>> Isn't what you are telling explained in Returning Cursors section on below >> link: >> http://www.postgresql.org/docs/9.1/static/plpgsql-cursors.html >Yes, but nowhere in: > http://www.postgresql.org/docs/current/static/sql-fetch.html > and IMO not clearly enough in the PL/PgSQL docs; it only appears in > sample code. Ref-cursors usage is also along with functions, so mentioning them along with PL/PgSQL docs looks more logical to me. However in context of SQL statements also Fetch can use internally generated cursor names in quoted strings, so about that some description might be useful. But again I don't know clearly the usage of it, whether such kind of functionality is used by users or PG is expecting to get Fetch used in such contexts. With Regards, Amit Kapila. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers