Re: [SQL] How to get last 10 rows in a table on a large database?

Stoyan Genov <genov@digsys.bg> writes:
> 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.

However, the "move" is a tad slow since the silly thing actually scans
over all the tuples in index order :-(.  This might not be a useful
solution for Alex's problem after all, because of the time taken by
the "move".
        regards, tom lane