Yes, yes, that's very important and I can't believe I left it out.. Sorry
about that.
Thanks Tom..
-Mitch
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Mitch Vincent" <mitch@venux.net>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, February 20, 2001 4:15 PM
Subject: Re: Re: Printing PostgreSQL reports
> "Mitch Vincent" <mitch@venux.net> writes:
> > ... use LIMIT X to only grab the first X records from
> > a result set. Then on the next page you say LIMIT X OFFSET X (in this
> > example it's more of a <Next 10 results> type of thing).
>
> Don't forget to use an ORDER BY clause that constrains the rows into a
> unique order, else you may get inconsistent results from the successive
> LIMITed queries.
>
> regards, tom lane
>