Re: Oracle compatibility ... - Mailing list pgsql-patches

From Tom Lane
Subject Re: Oracle compatibility ...
Date
Msg-id 3065.1089436169@sss.pgh.pa.us
Whole thread Raw
In response to Oracle compatibility ...  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-patches
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres@cybertec.at> writes:
> [ patch to support MINUS as a synonym for EXCEPT ]

I can't agree with doing this.  MINUS is not a reserved word according
to SQL99, so supporting Oracle's syntax reduces our spec compatibility
by a visible amount.  And for what?  The behavior is *exactly* the same,
and all recent versions of Oracle accept the SQL-standard spelling
EXCEPT.

I counsel telling your customer to fix his application.  A quick
s/MINUS/EXCEPT/g on his part won't cost anything.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: build infrastructure for extensions v3
Next
From: Tom Lane
Date:
Subject: Re: Digital Mars C++ - Clients