Re: jdbc cursor positioning - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: jdbc cursor positioning
Date
Msg-id 1033951736.20053.0.camel@inspiron.cramers
Whole thread Raw
In response to Re: jdbc cursor positioning  (Toby <toby@paperjet.com>)
List pgsql-jdbc
No, postgres fully supports cursors, the problem must be somewhere else.

Dave
On Sun, 2002-10-06 at 15:27, Toby wrote:
> 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




pgsql-jdbc by date:

Previous
From: Toby
Date:
Subject: Re: jdbc cursor positioning
Next
From: Aaron Mulder
Date:
Subject: DBMD Patch