when using the RETURNING clause in a DELETE statement the driver throws an error:
org.postgresql.util.PSQLException: A result was returned when none was expected.
The code that I'm using is as follows:
Statement stmt = connection.createStatement();
stmt.executeUpdate("delete from person where firstname like 'A%' returning id");
Am I missing something or is the "RETURNING" feature not supported by the driver?
I'm using postgresql-8.4-701.jdbc3.jar with Java5
pgsql-jdbc by date
|Next:||From: Dennis Brakhane||Date: 2009-07-13 19:51:01|
|Subject: Re: DELETE ... RETURNING|
|Previous:||From: Thomas Kellerer||Date: 2009-07-13 19:37:08|
|Subject: No 8.4 documentation on the JDBC website|