| 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: | Whole Thread | Raw Message | 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
| 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 |