| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | Ragnar Hafstað <gnari(at)simnet(dot)is>, Alain <alainm(at)pobox(dot)com> |
| Cc: | Sql-Postgre <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Does Postgresql have a similar pseudo-column "ROWNUM" as |
| Date: | 2005-05-17 22:13:46 |
| Message-ID: | op.sqxxc81sth1vuj@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ragnar Hafstað | 2005-05-17 22:27:54 | Re: Does Postgresql have a similar pseudo-column "ROWNUM" as |
| Previous Message | Ragnar Hafstað | 2005-05-17 22:03:02 | Re: Does Postgresql have a similar pseudo-column "ROWNUM" as |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ragnar Hafstað | 2005-05-17 22:27:54 | Re: Does Postgresql have a similar pseudo-column "ROWNUM" as |
| Previous Message | Ragnar Hafstað | 2005-05-17 22:03:02 | Re: Does Postgresql have a similar pseudo-column "ROWNUM" as |