On Fri, 19 Oct 2007 18:19:55 -0500
Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Oct 19, 2007, at 16:03 , Josh Trutwin wrote:
>
> > SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y;
>
> The server will have to generate at most OFFSET + LIMIT rows,
> returning LIMIT row
On Oct 19, 2007, at 16:03 , Josh Trutwin wrote:
SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y;
The server will have to generate at most OFFSET + LIMIT rows,
returning LIMIT rows or fewer.
SELECT * FROM table WHERE foo="bar" ORDER BY abc;
This will return all of the