Re: [PATCHES] extension for sql update - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] extension for sql update
Date
Msg-id 6000.1154006240@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] extension for sql update  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [PATCHES] extension for sql update  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> UPDATE mytab SET (foo, bar, baz) =
>> (SELECT alpha, beta, gamma FROM othertab WHERE key = mytab.key);

> That UPDATE example is interesting because I remember when using
> Informix that I had to do a separate SELECT statement for each UPDATE
> column I wanted to update.  I didn't realize that you could group
> columns and assign them from a single select --- clearly that is a
> powerful syntax we should support some day.

No question.  The decision at hand is whether we want to look like
we support it, when we don't yet.  I'd vote not, because I think the
main use-case for the row-on-the-left syntax is exactly this, and
so I fear people will just get frustrated if they see it in the
syntax synopsis and try to use it.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] extension for sql update
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] extension for sql update