Re: UPDATE ... SET (a, b, c) = (expr) - Mailing list pgsql-hackers

From Nikhil Sontakke
Subject Re: UPDATE ... SET (a, b, c) = (expr)
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: UPDATE ... SET (a, b, c) = (expr)  (Alvaro Herrera <[email protected]>)
List pgsql-hackers
Hi Alvaro,

>
>> But then there's the matter of how to represent it from the grammar
>> inwards.  At first I thought of creating a new parse node type, say
>> MultiResTarget that would replace ResTarget in UpdateStmt, and get it
>> from there into the optimizer and executor.
>
> Hmm, I should be passing it as a Query node, right?
>

I had (rather unsuccessfully) tried my hands on this same TODO a while
back. Here is what Tom had to say about my approach:

http://www.nabble.com/UPDATE-using-sub-selects-td9935249.html#a16108043

Also attached is the discussion on hackers to provide some more context:
http://www.nabble.com/UPDATE-using-sub-selects-td9489091.html
Might not be a big help, but just wanted to mention it here..

Regards,
Nikhils
--
http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: WIP: generalized index constraints
Next
From: Jeff Janes
Date:
Subject: XLogFlush