Re: problem to get nextval of a sequence

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: pg(at)fastcrypt(dot)com
Cc: Daniel Schaedler <postgres-jdbc(at)daniel(dot)schaedler(dot)name>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: problem to get nextval of a sequence
Date: 2004-12-28 14:56:29
Message-ID: 87oegea2ua.fsf@meuh.mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dave Cramer <pg 'at' fastcrypt.com> writes:

> Daniel,
>
> The spec says that you must call next to position the cursor. What
> happens if nothing comes back? ie an empty result set ?

With previous versions of postgres (and/or the jdbc driver?) it
was possible to get results with the cursor positioned before the
first row; it returned results from the first row. That's
probably the reason of the buggy code of Daniel.

--
Guillaume Cottenceau

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Marlowe 2004-12-28 15:48:49 Re: Open connections
Previous Message Dave Cramer 2004-12-28 14:23:26 Re: Open connections