Re: [PATCHES] INSERT ... RETURNING

2005-07-30 Thread Omar Kilani
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

Re: [PATCHES] INSERT ... RETURNING

2005-07-29 Thread Bruce Momjian
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

Re: [PATCHES] INSERT ... RETURNING

2005-07-29 Thread Kevin McArthur
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

Re: [PATCHES] INSERT ... RETURNING

2005-07-06 Thread Neil Conway
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]

Re: [PATCHES] INSERT ... RETURNING

2005-07-05 Thread Tom Lane
[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

[PATCHES] INSERT ... RETURNING

2005-07-04 Thread omar
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