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