Re: select question - Mailing list pgsql-general

From Ian Turner
Subject Re: select question
Date
Msg-id Pine.LNX.4.21.0007291143400.1020-100000@crafter.house
Whole thread Raw
In response to select question  (<database@gurubase.com>)
List 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-----


pgsql-general by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: select question
Next
From: Jouni Ahto
Date:
Subject: Re: [PHP-INST] problem compiling php for pgsql