offset for query result ??

From: Kathy Zhu <Kathy(dot)Zhu(at)Sun(dot)COM>
To: pgsql-general(at)postgresql(dot)org
Subject: offset for query result ??
Date: 2003-11-17 23:17:20
Message-ID: 3FB95700.403A4FA9@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Troels Arvin 2003-11-17 23:25:36 Re: offset for query result ??
Previous Message Robert Treat 2003-11-17 22:58:34 tracking down temp files