Re: jdbc cursor positioning

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