| From: | Toby <toby(at)paperjet(dot)com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: jdbc cursor positioning |
| Date: | 2002-10-06 19:27:13 |
| Message-ID: | 5.1.0.14.0.20021006202100.00a73c58@mail.flirble.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg토토 캔SQL : Postg토토 캔SQL 메일 링리스트 : 2002-10-06 이후 PGSQL-JDBC 19:27 |
as i understand it, postgres doesn't yet support cursors. however, with the
LIMIT and OFFSET modifiers in a SELECt you can get the same behaviour.
SELECT <fields> FROM <table> ORDER BY <field> LIMIT <recsPerPage>
OFFSET <offset>
<fields> is the fields to select
<table> is the table you're selecting from
<recsPerPage> is an integer 1..n for the number of records per page.
<offset> is calculated as ((page - 1) * recsPerPage) where the page number
is 1..n
make sure you order your select by something, else the records in a page
may not quite make sense.
toby
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-10-07 00:48:55 | Re: jdbc cursor positioning |
| Previous Message | G.Nagarajan | 2002-10-06 14:50:07 | jdbc cursor positioning |