On Oct 28, 2013, at 6:13 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote: > On 10/28/2013 3:58 PM, Adrian Klaver wrote: >> The docs do a good job of illustrating: >> >> http://www.postgresql.org/docs/9.3/interactive/plpgsql-cursors.html > > thats for cursors created within a plpgsql function. > > I think what the OP wants is a top level cursor, which is a different thing... > > see > http://www.postgresql.org/docs/current/static/sql-declare.html > http://www.postgresql.org/docs/current/static/sql-fetch.html > http://www.postgresql.org/docs/current/static/sql-close.html > > the fetch page shows an example of the complete usage in the context of a database transaction. Thank you to Merlin. I now understand better where my confusion was. John: Those examples are great except there is no way that I know of to loop on the "top level" as you call it. I'm trying to do something that I can give to psql which will loop through the entire set that is produced. I came across the FOR-IN loop but that needs a function. But as Merlin points out, the function is on the server side and I need the loop on the client side. Perhaps the \set FETCH_COUNT 500000 solution that Merln point out originally is the only choice. I feel like I've learned a lot even though it might not have been what I was originally trying to learn :-) Thank you again, Perry
Attachment:
signature.asc
Description: Message signed with OpenPGP using GPGMail
