Hi,
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
Regards
Thomas