Re: Printing PostgreSQL reports
От | Mitch Vincent |
---|---|
Тема | Re: Printing PostgreSQL reports |
Дата | |
Msg-id | 05c601c09b78$9ff813b0$0200000a@windows обсуждение исходный текст |
Ответ на | Printing PostgreSQL reports (Richard Ehrlich <richard@techspt.com>) |
Ответы |
Re: Re: Printing PostgreSQL reports
|
Список | 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.. 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 > >
В списке pgsql-general по дате отправления: