Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Dale <harris_da(at)yahoo(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Date: 2008-08-19 15:17:52
Message-ID: 20080819111752.c6171cf1.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to Alvaro Herrera <alvherre(at)commandprompt(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-08-19 15:21:58 Re: Idle in transcation problem?
Previous Message Alvaro Herrera 2008-08-19 14:49:09 Re: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully