Re: DELETE ... RETURNING - Mailing list pgsql-jdbc

From Dennis Brakhane
Subject Re: DELETE ... RETURNING
Date
Msg-id [email protected]
Whole thread Raw
In response to DELETE ... RETURNING  (Thomas Kellerer <[email protected]>)
Responses Re: DELETE ... RETURNING
List pgsql-jdbc
On Mon, Jul 13, 2009 at 9:44 PM, Thomas Kellerer<[email protected]> wrote:
> 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?

executeUpdate by definitionem can only return an int, the number of
rows affected.

You probably can use stmt.executeQuery instead

pgsql-jdbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: DELETE ... RETURNING
Next
From: Thomas Kellerer
Date:
Subject: Re: DELETE ... RETURNING