Re: [SQL] INSERT INTO...RETURNING vs SELECT

2010-04-05 Thread Cliff Wells
On Mon, 2010-04-05 at 09:10 +0200, Andreas Kretschmer wrote: > Cliff Wells 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 mome

Re: [SQL] INSERT INTO...RETURNING vs SELECT

2010-04-05 Thread Andreas Kretschmer
Cliff Wells 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, writeabl