offset for query result ?? - Mailing list pgsql-general

From Kathy Zhu
Subject offset for query result ??
Date
Msg-id 3FB95700.403A4FA9@Sun.COM
Whole thread Raw
In response to pg_constraint missing many entries?  (Jeff Boes <jboes@nexcerpt.com>)
Responses Re: offset for query result ??
List pgsql-general
Hi all,

I know we have LIMIT to limit the number of rows returned, I wonder if there is
a way to indicate an offset.

e.g.

Select * from Test offset 10, limit 4;

retrieve all Test, return 4 rows from the 10th row


thanks,
kathy




pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: tracking down temp files
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL v7.4 Released