Re: Dyamic updates of NEW with pl/pgsql - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Dyamic updates of NEW with pl/pgsql
Date
Msg-id b42b73151003121217p19938662p55d61729d96e6a28@mail.gmail.com
Whole thread Raw
In response to Re: Dyamic updates of NEW with pl/pgsql  (Boszormenyi Zoltan <zb@cybertec.at>)
Responses Re: Dyamic updates of NEW with pl/pgsql
List pgsql-hackers
On Fri, Mar 12, 2010 at 3:01 PM, Boszormenyi Zoltan <zb@cybertec.at> wrote:
>
> What's wrong with "UPDATE foo SET (foo) = (NEW);" ?
>

amen brother! :-)

I say though, since you can do:
SELECT foo FROM foo;
why not
UPDATE foo SET foo = new;?

merlin


pgsql-hackers by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: Re: Dyamic updates of NEW with pl/pgsql
Next
From: Tom Lane
Date:
Subject: Re: buildfarm logging versus embedded nulls