| From: | Ian Turner <vectro(at)pipeline(dot)com> |
|---|---|
| To: | database(at)gurubase(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: select question |
| Date: | 2000-07-29 18:43:58 |
| Message-ID: | Pine.LNX.4.21.0007291143400.1020-100000@crafter.house |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc.... (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different page.
Look at the documentation for the 'limit' clause.
Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE5gyXxfn9ub9ZE1xoRAiIRAKCF4CCP3CGVVl+aY4jmdP+def2JYQCfRg8e
zWP3OaPFXxr34n8FMSV4N4A=
=33xl
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2000-07-29 19:51:51 | Re: problem compiling php for pgsql |
| Previous Message | Alfred Perlstein | 2000-07-29 18:30:48 | Re: select question |