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

Поиск
Список
Период
Сортировка
От Stoyan Genov
Тема Move forward all (Was Re: How to get last 10 rows in a table on a large database?)
Дата
Msg-id 199911071025.MAA25941@lorna.digsys.bg
обсуждение исходный текст
Ответ на Re: [SQL] How to get last 10 rows in a table on a large database?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: [SQL] How to get last 10 rows in a table on a large database?
Следующее
От: "José A. Navarro Ramón"
Дата:
Сообщение: subscribe pgsql-sql