hello experts
i am a newbie to this postgress sql

i wanted to know how to implement paging with postgress sql

i have 100 records in my table
when i click on the next button it should fetch next records and so on

how the query will be in postgress???

The same way you're used to doing it in MySQL, LIMIT and OFFSET

PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: LIMIT and OFFSET