Re: Cursor Example Needed

On Oct 28, 2013, at 6:13 PM, John R Pierce <pierce(at)hogranch(dot)com> 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