Postgres Pro
Downloads
Home   >   mailing lists

Re: getGeneratedKeys() support? - Mailing list pgsql-jdbc

From Andrew Lazarus
Subject Re: getGeneratedKeys() support?
Date
Msg-id 462642779.20070830143217@attglobal.net
Whole thread Raw
In response to getGeneratedKeys() support?  (Benjamin Shive <bshive@comcast.net>)
List pgsql-jdbc
Tree view 
The current JDBC driver supports the RETURNING clause and it does
exactly what someone would want.

ResultSet rs = statement.executeQuery("INSERT INTO z(myField) VALUES(0)
RETURNING keyName") ;
int key = rs.getInt(1);

Hallelujah

pgsql-jdbc by date:

Previous
From: Dominik Bruhn
Date:
Subject: Retrieving Columns by table-alias
Next
From: "Albe Laurenz"
Date:
Subject: Re: Retrieving Columns by table-alias