Re: Re: Printing PostgreSQL reports

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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mitch Vincent" <mitch(at)venux(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 20, 2001 4:15 PM
Subject: Re: Re: Printing PostgreSQL reports

> "Mitch Vincent" <mitch(at)venux(dot)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
>