Re: PHP & Postgres Displaying Results
| From: | Lic. Luis Reynel Sales Glez. | Date: | Thu, 21 Sep 2000 19:31:17 +0000 |
| Subject: | Re: PHP & Postgres Displaying Results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3033@lists.php.net to get a copy of this message | ||
Hi Chris & *:
In PostgreSQL you can use limit n and offset x.
where
n = Total amount of fields you want to get from the query
x = First record to obtain
In this way, doing
select * from table where condition limit 4 offset 1;
will return to you records from 2 to 5 (Remember first record is 0).
Hope it helps you.
Regards,
--
Luis R. Sales Gonzalez
WebMaster
Sony Latin America
mailto: lrsg@intradev.sola.sony.com