Re: Printing PostgreSQL reports

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..

It's written in PHP and customized on a per application basis so the actual
source code wouldn't do anyone much good but the basic idea is to group
results X at a time, then 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).. You can get
creative and do pretty meat paging systems with PG.

Good luck!

-Mitch


----- Original Message -----
From: "Richard Ehrlich" <richard@techspt.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, February 20, 2001 3:00 PM
Subject: Printing PostgreSQL reports


> I can post info to PostgreSQL from a webform via JSP, and I can post
> reports from PostgreSQL to a webpage. Can anyone tell me how I might
format
> a PostgreSQL report to a web page so that it will print discrete,
sequenced
> pages?
>
> Thanks,
> Richard Ehrlich
>
>