Re: Does Postgresql have a similar pseudo-column "ROWNUM" as - Mailing list pgsql-sql

> your subsequent selects are
> select ... from tab WHERE skey>skey_last
>                        OR (skey=skey_last AND pkey>pkey_last)
>                     ORDER BY skey,pkey
>                     LIMIT 100 OFFSET 100;
why offset ?you should be able to use the skey, pkey values of the last row on the  
page to show the next page, no need for offset then.