Bruce,
Are you still working on completing this?
Attached is my latest rewrite of this patch.
Basically, it adds RETURNING to INSERT/UPDATE/DELETE, and allows
arbitrary expressions.
I'm still not sure how to handle DELETE ... USING and UPDATE ... FROM as
I don't see a way to project the
Are you still working on completing this?
---
[EMAIL PROTECTED] wrote:
Hi there,
Attached is a patch (by Gavin Sherry, fixed up to apply to 8.1 by me) that
implements INSERT ... RETURNING functionality.
It does work
McArthur
- Original Message -
From: Bruce Momjian pgman@candle.pha.pa.us
To: [EMAIL PROTECTED]
Cc: pgsql-patches@postgresql.org
Sent: Friday, July 29, 2005 7:26 PM
Subject: Re: [PATCHES] INSERT ... RETURNING
Are you still working on completing
Tom Lane wrote:
- should work for UPDATE and DELETE too
And probably INSERT ... SELECT as well.
-Neil
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[EMAIL PROTECTED] writes:
Attached is a patch (by Gavin Sherry, fixed up to apply to 8.1 by me) that
implements INSERT ... RETURNING functionality.
It does work for the common case of RETURNING the value of a serial/sequence
column, but gets confused when returning results out-of-order
Hi there,
Attached is a patch (by Gavin Sherry, fixed up to apply to 8.1 by me) that
implements INSERT ... RETURNING functionality.
It does work for the common case of RETURNING the value of a serial/sequence
column, but gets confused when returning results out-of-order (CREATE TABLE x
(a int, b