displaying records from X to Y - Mailing list pgsql-novice

From Mel Jamero
Subject displaying records from X to Y
Date
Msg-id 000401c274bb$4bce41b0$1b06a8c0@mel
Whole thread Raw
In response to Re: test geometry ... FAILED  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: displaying records from X to Y
List pgsql-novice
hi!

i can access the first 100 records by this command:

=> select * from foo_table limit 100;
OR
=> select * from foo_table order by foo_column desc limit 100;

how do i access the next 100 records without having the first 100 displayed?

thanks!

mel


pgsql-novice by date:

Previous
From: János Löbb
Date:
Subject: jdbc connection from Eomodeler to postgresql 7.2.3
Next
From: "Josh Berkus"
Date:
Subject: Re: displaying records from X to Y