Re: request for sql3 compliance for the update command - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: request for sql3 compliance for the update command
Date
Msg-id 050601c2d885$2440c630$6500a8c0@fhp.internal
Whole thread Raw
In response to Re: request for sql3 compliance for the update command  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> While I don't see the syntax of:
> 
> update table set (col...) = ( val...)
> 
> as valuable compared to separate col=val assignments, I do see a value
> in allowing subqueries in such assignments:
> 
> update table set (col...) = ( select val ..)
> 
> Without it, you have to do separate subquery statements, and if they are
> complex, that is a waste.  I assume that was the motivation for the
> feature.

The number of times I've needed this feature... :)

Chris




pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Detecting corrupted pages earlier
Next
From: Justin Clift
Date:
Subject: Re: request for sql3 compliance for the update command