Thread: LIMITS in SELECTs

Hi !

Is there a way to select only a range of rows from a table, using a  command
like:

SELECT * FROM table WHERE where_statement LIMIT 50,100;



I've tried, and then read the doc, but found no information so far.

Thanks in advance.



Fabrice Scemama

On Sat, 9 Jan 1999, Fabrice Scemama wrote:

// Is there a way to select only a range of rows from a table, using a  command
// like:
//
// SELECT * FROM table WHERE where_statement LIMIT 50,100;

    That doesn't make sense in a relational database by itself since
it's not guaranteed to return any particular dataset in any particular
order.  What you want is a cursor.

// I've tried, and then read the doc, but found no information so far.
//
// Thanks in advance.
//
//
//
// Fabrice Scemama
//
//

--
Principle Member Technical Staff, beyond.com    The world is watching America,
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __

Hi,

> Is there a way to select only a range of rows from a table, using
> a  command
> like:
>
> SELECT * FROM table WHERE where_statement LIMIT 50,100;

Assuming you use a "Order By" clause to make sure you got the records in the
appropriate order there is a patch file in the "patches" directory of
ftp.postgresql.org which adds the "LIMIT" command to PostgreSQL 6.4.x

I've not tried it, so cannot say how well it works, or if it can do limits
between 2 values, but you can give it a shot.

Regards,

Neil