Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Scott MarloweDate: 2004-12-28 15:48:49
Subject: Re: Open connections
Previous:From: Dave CramerDate: 2004-12-28 14:23:26
Subject: Re: Open connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group