Re: jdbc cursor positioning

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