Re: INSERT INTO...RETURNING vs SELECT

From: Cliff Wells <cliff(at)develix(dot)com>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: INSERT INTO...RETURNING vs SELECT
Date: 2010-04-05 15:40:24
Message-ID: 1270482024.4749.161.camel@portable-evil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 2010-04-05 at 09:10 +0200, Andreas Kretschmer wrote:
> Cliff Wells <cliff(at)develix(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lee Hachadoorian 2010-04-06 17:33:18 Table Design for Hierarchical Data
Previous Message Andreas Kretschmer 2010-04-05 07:10:26 Re: INSERT INTO...RETURNING vs SELECT