Re: Why doesn't update syntax match insert syntax?

> On Thu, Oct 10, 2013 at 10:03 AM, Rob Richardson
> <RDRichardson(at)rad-con(dot)com> wrote:
>
> > UPDATE inner_covers
> > SET X = (SELECT sl.X FROM storage_locations sl where sl.name = inner_covers.name),
> > Y = (SELECT sl.Y FROM storage_locations sl where sl.name = inner_covers.name)
> >
> > Or is there another, more convenient form of the UPDATE query that I'm not familiar with?
> >
> > Thanks very much!
>
> you have UPDATE FROM:
>
> UPDATE foo SET a=bar.a, b=bar.b
> FROM bar WHERE foo.id = bar.id;
>
> merlin

Hi,

an alternate syntax which is nearer to the INSERT one:

update foo set (a,b) = (bar.a, bar.b)
FROM bar
WHERE foo.id = bar.id;

I guess this is just a question of taste...

regards,

Marc Mamin