LIMITS in SELECTs - Mailing list pgsql-general

From Fabrice Scemama
Subject LIMITS in SELECTs
Date
Msg-id 199901091327.OAA28333@gesnet.gesnet.net
Whole thread Raw
Responses Re: [GENERAL] LIMITS in SELECTs  (dustin sallings <dustin@spy.net>)
RE: [GENERAL] LIMITS in SELECTs  ("Neil Burrows" <maillist@remo.demon.co.uk>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7
Next
From: "Richard Vaughan"
Date:
Subject: Databases on Linux