Re: INSERT INTO...RETURNING vs SELECT - Mailing list pgsql-sql

From Cliff Wells
Subject Re: INSERT INTO...RETURNING vs SELECT
Date
Msg-id 1270482024.4749.161.camel@portable-evil
Whole thread Raw
In response to Re: INSERT INTO...RETURNING vs SELECT  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-sql
On Mon, 2010-04-05 at 09:10 +0200, Andreas Kretschmer wrote:
> Cliff Wells <cliff@develix.com> wrote:
> 
> > As far as I can see, INSERT INTO...RETURNING is semantically equivalent
> > to SELECT...FROM with a side-effect, so it seems this construct should
> > work.  Can someone shed some light?
> 
> Well, at the moment you can't reuse the RETURNING-values, you have to
> wait for 9.1, writeable CTE.

Thanks, I just wanted to make sure I wasn't misunderstanding something.

Regards,
Cliff



pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: INSERT INTO...RETURNING vs SELECT
Next
From: junaidmalik14
Date:
Subject: count function alternative in postgres