Re: Printing PostgreSQL reports - Mailing list pgsql-general

From Gregory Wood
Subject Re: Printing PostgreSQL reports
Date
Msg-id 001f01c09b7f$eb36c180$7889ffcc@comstock.com
Whole thread Raw
In response to Printing PostgreSQL reports  (Richard Ehrlich <richard@techspt.com>)
Responses C function woes  (Chris Hayner <hayner80@astro.ocis.temple.edu>)
List pgsql-general
> I wrote a paging system that I use for all my applications that take full
> advantage of PostgreSQL's killer LIMIT and OFFSET features. I'd suggest
you
> do the same, it's worked very well for me so far..

Personally I really favor the idea of using LIMIT and OFFSET, I just thought
I'd add this little caution: if the table is updated between queries, the
results could be thrown off. So if you need a static set of results, you'll
need to do a little bit more.

Greg


pgsql-general by date:

Previous
From: Tom Jenkins
Date:
Subject: Re: INSERT INTO problem
Next
From: Tom Lane
Date:
Subject: Re: Re: A How-To: PostgreSQL from Tcl via ODBC