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" 
To: "Mitch Vincent" 
Cc: 
Sent: Tuesday, February 20, 2001 4:15 PM
Subject: Re: Re: Printing PostgreSQL reports


> "Mitch Vincent"  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  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
>