On 3 February 2018 at 23:17, Peter Geoghegan <p...@bowt.ie> wrote:
> On Sat, Feb 3, 2018 at 2:15 PM, Simon Riggs <si...@2ndquadrant.com> wrote:
>>> I started looking at SQL Server's MERGE to verify that it also does
>>> not impose any restrictions on subselects in a MERGE UPDATE's
>>> targetlist, just like Oracle. Unsurprisingly, it does not. More
>>> surprisingly, I noticed that it also doesn't seem to impose
>>> restrictions on what can appear in WHEN ... AND quals.
>> You earlier agreed that subselects were not part of the Standard.
> You know that I didn't say that, Simon.
I'm happy to quote your words.
"I've acknowledged that the standard has something to
say on this that supports your position, which has real weight."
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services