"Postgres User" <postgres(dot)developer(at)gmail(dot)com> writes:
> Is there any way to 'rewind' the cursor to the first row?

plpgsql doesn't have any command for that (though I think someone is
working on improving its cursor command set).  You should be able to
work around it by EXECUTE'ing a MOVE BACKWARD ALL command, though.
You just need to know the real name of the cursor --- see 'Returning
Cursors' in the plpgsql docs for discussion.

			regards, tom lane

In response to

• Fun with Cursors- how to rewind a cursor at 2007-03-02 00:29:34 from Postgres User

Responses

• Re: Fun with Cursors- how to rewind a cursor at 2007-03-02 03:39:01 from Postgres User

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2007-03-02 01:08:32
	Subject: Re: SOC & user quotas
Previous:	From: Sergey E. Koposov	Date: 2007-03-02 00:31:44
	Subject: Re: SOC & user quotas

pgsql-general by date

Next:	From: Tom Lane	Date: 2007-03-02 01:16:29
	Subject: Re: Constraint validation
Previous:	From: mobiledreamers	Date: 2007-03-02 01:04:36
	Subject: Re: US Highschool database in postgres