Re: getGeneratedKeys

From: Kris Jurka <books(at)ejurka(dot)com>
To: Saleem EDAH-TALLY <nmset(at)netcourrier(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: getGeneratedKeys
Date: 2009-03-09 22:39:03
Message-ID: Pine.BSO.4.64.0903091837300.4875@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 9 Mar 2009, Saleem EDAH-TALLY wrote:

> I've tried for single and multiple inserts and it does work.
> I don't know what would be returned if a table has more than one sequence as
> default value for columns, I don't have need for this so I won't try.
>
> Just for curiosity, does it work by driver implementation solely or are there
> changes in PostgreSQL backend that help the implementation ?

The 8.2 server release included support for the RETURNING clause for
inserts, updates, and deletes which allow the server to return the values
generated.

http://www.postgresql.org/docs/8.3/static/sql-insert.html

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2009-03-09 23:36:10 Re: Query much slower when run from postgres function
Previous Message Saleem EDAH-TALLY 2009-03-09 22:26:44 Re: getGeneratedKeys