Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully - Mailing list pgsql-general

From Bill Moran
Subject Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Date
Msg-id 20080819111752.c6171cf1.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
In response to Alvaro Herrera <alvherre@commandprompt.com>:

> Bill Moran wrote:
>
> > Is it possible that your UPDATE command is updating multiple rows?  I
> > don't believe RETURNING will work on an UPDATE that touches more than 1
> > row.
>
> Hmm, why not?

Because a doc linked to earlier in this thread said so.

Can't find it now, so it's possible that I misread it or was suffering
from temporal insanity.

oops ...

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Next
From: Tom Lane
Date:
Subject: Re: Idle in transcation problem?