Paul Tomblin wrote:
> Be that as it may, I still don't see what you gain by doing
> insert ... (nextval('idseq'),...
> select currval('idseq');
> when you could do
> select nextval('idseq');
> insert ...(?,...
Oh, sure, there's not gain either way. Select nextval + insert works
just as well.
Theoretically, you could "pipeline" the "INSERT nextval" + "SELECT
currval" method, by sending both commands at once and only then block
and wait for response, saving one round-trip to the server. You could do
that with a batch statement, I think, or by single executeQuery("INSERT
... ; SELECT currval(...)"). But if you don't do that, there's no
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2008-02-20 17:18:43|
|Subject: Re: extra rowcopy in ResultSet allways needed ?.|
|Previous:||From: Paul Tomblin||Date: 2008-02-20 14:03:14|
|Subject: Re: Retrieving last InsertedID : INSERT... RETURNING safe ?|