Move forward all (Was Re: How to get last 10 rows in a table on a large database?) - Mailing list pgsql-sql

From Stoyan Genov
Subject Move forward all (Was Re: How to get last 10 rows in a table on a large database?)
Date
Msg-id 199911071025.MAA25941@lorna.digsys.bg
Whole thread Raw
In response to Re: [SQL] How to get last 10 rows in a table on a large database?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?)  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-sql
> > You are unable to say:
> >     begin transaction;
> >         declare tbl_cur cursor for .... .....
> >         move forward all in tbl_cur;
> >         fetch backward 10 in tbl_cur;
> >         ...........
> >     end transaction;
> > because when you "move forward all" the result gets lost.
> 
> Huh?  It seems to work fine for me.

Well, it does not seem to work for me neither on the 6.4.2 nor on the 
6.5.(1|2)
version. I'll try 6.5.3 as well... 
Any ideas why this is so?

Regards,Stoyan Genov



pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [SQL] How to get last 10 rows in a table on a large database?
Next
From: "José A. Navarro Ramón"
Date:
Subject: subscribe pgsql-sql