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

From Pavel Stehule
Subject Re: SET syntax in INSERT
Date
Msg-id CAFj8pRA+aOXgraxCBQe_fnVK5p0SSKAFRrFJJUsYcJg1PxPPkg@mail.gmail.com
Whole thread Raw
In response to Re: SET syntax in INSERT  (Marko Tiikkaja <marko@joh.to>)
Responses Re: SET syntax in INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers


2016-01-14 20:09 GMT+01:00 Marko Tiikkaja <marko@joh.to>:
On 2016-01-14 8:06 PM, Pavel Stehule wrote:
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.

So is RETURNING,

is it ANSI SQL redundant?
 
UPSERT,

the behave is partially different than MERGE, so different syntax is 100% valid
 
PL/PgSQL and many other useful features.

PL/pgSQL is PL/SQL clone, and because the base is Ada, it cannot be compatible with SQL/PSM.

Regards

Pavel
 


.m

pgsql-hackers by date:

Previous
From: Marc Mamin
Date:
Subject: Re: SET syntax in INSERT
Next
From: Tom Lane
Date:
Subject: Re: SET syntax in INSERT