By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

Pagination in Postgre

exoskeleton
100+
P: 104
Hi guys...need help here ...
My problem is about pagination like <<PREV 1,2,3,4,5,6 NEXT>>

Does LIMIT Function applicable in PostgreSQL?

[PHP]$SQL="SELECT * FROM TABLE1 LIMIT 0,5";[/PHP]

the sql above works in MySQL but in PostgreSQL failed...

any idea how or whats the alternative way? or i just miss something?

please guys help

Thank you in advance...
Mar 8 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
In Postgresql database you may need to use both, LIMIT and OFFSET

And here's one practical article on pagination with Postgres.
Mar 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.