should
be fine for most medium sized servers I guess.
Peter
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 20, 2002 8:53 PM
Subject: [SQL] Need help paging through record sets
Hello everyone, and thanks for reading my first ne
Sort of depends on the nature of your application. You can use offset to get
specific chunks:
select * from foo order by date limit 100 offset 100;
You should be aware, however, that on a very large table this can be quite
inefficient as you will have to do the select and sort on the large tabl
Hello everyone, and thanks for reading my first newbie post. :-)
I am a neopyhte PHP and postgreSQL user, with a website at www.the-athenaeum.org. We
store (among other things) artworks, which people can view in a list, sorted by artist
name, date, medium, etc.
We now have enough works that I
