Re: SET syntax in INSERT - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: SET syntax in INSERT
Date
Msg-id 5697FBA1.8050709@joh.to
Whole thread Raw
In response to Re: SET syntax in INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2016-01-14 20:33, Tom Lane wrote:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>>>> Probably there is less risk than 7 years ago, but still creating own
>>>> syntax isn't the best idea. This is syntactic sugar only and different
>>>> from ANSi SQL or common standard.
>
> It's more than syntactic sugar; you are going to have to invent semantics,
> as well, because it's less than clear what partial-field assignments
> should do.

I don't really care for such.  In my opinion it would be fine if this 
simply was only "syntactic sugar", and trying to do any tricks like this 
would simply raise an exception.


.m



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SET syntax in INSERT
Next
From: Vitaly Burovoy
Date:
Subject: Re: SET syntax in INSERT