> 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