Postgres Pro
Downloads
Home   >   mailing lists

Re: Fun with Cursors- how to rewind a cursor - Mailing list pgsql-general

From Tom Lane
Subject Re: Fun with Cursors- how to rewind a cursor
Date
Msg-id 1646.1172813624@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fun with Cursors- how to rewind a cursor  ("Postgres User" <postgres.developer@gmail.com>)
Responses Re: Fun with Cursors- how to rewind a cursor  ("Postgres User" <postgres.developer@gmail.com>)
List pgsql-general
Tree view 
"Postgres User" <postgres.developer@gmail.com> writes:
> So I added the following code:

> <before opening cursor>     ref_entry = 'c_entry';
> <after looping thru cursor>  MOVE Backward All In c_entry;

You have to use EXECUTE for the latter.

            regards, tom lane

pgsql-general by date:

Previous
From: "Eddy D. Sanchez"
Date:
Subject: Re: Add items to a record variable
Next
From: "Postgres User"
Date:
Subject: Re: Fun with Cursors- how to rewind a cursor