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

From: Stoyan Genov <genov(at)digsys(dot)bg>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Move forward all (Was Re: How to get last 10 rows in a table on a large database?)
Date: 1999-11-07 10:25:08
Message-ID: 199911071025.MAA25941@lorna.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stoyan Genov 1999-11-07 10:50:41 Re: [SQL] Accessing other database...
Previous Message Oleg Bartunov 1999-11-06 19:09:48 Re: [SQL] How to get last 10 rows in a table on a large database?