Horton

Re: SQL-question: returning the id of an insert querry

Paul Thomas <paul@tmsl.demon.co.uk>

View thread View on postgr.es
From: Paul Thomas <paul@tmsl.demon.co.uk>
To: Kathy.Zhu@Sun.COM
Cc: "pgsql-general @ postgresql . org" <pgsql-general@postgresql.org>
Date: 2003-11-10T21:34:52Z
Lists: pgsql-general 
On 10/11/2003 17:22 Kathy Zhu wrote:
> I saw this method of Statement class in jdbc.
> Will the return int contain the autogenerated key value ??
> 
> public int executeUpdate(String sql,
>                          int autoGeneratedKeys)
>                   throws SQLException
> 
> thanks,
> kathy

This is one of a number of JDBC3 extensions which are just stub methods 
ATM. You'll find it will just throw an exception if called.


-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+