Skip site navigation (1) Skip section navigation (2)

Re: Oracle MINUS is not supported

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Oracle MINUS is not supported
Date: 2001-03-10 16:24:39
Message-ID: 01031022243907.00608@dyp.perchine.com (view raw or flat)
Thread:
Lists: pgsql-patches
On Saturday 10 March 2001 22:18, Tom Lane wrote:
> Denis Perchine <dyp(at)perchine(dot)com> writes:
> > Oracle has MINUS keyword used instead of EXCEPT.
>
> Doesn't Oracle also accept EXCEPT?  They claim to be SQL-compliant ...

Unfortunatly - no. At least 8.1.6 says very bad words about this... :-(((
Also there is only MINUS in SQL reference SELECT grammar.
I tried to execute SQL worked on PostgreSQL, and was forced to do 2 
corrections:
1. Replace EXCEPT with MINUS
2. Remove AS after subquery for target column

Both if I am not mistaken is ANSI/SQL. :-((

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-03-10 17:20:17
Subject: Re: Oracle MINUS is not supported
Previous:From: Tom LaneDate: 2001-03-10 16:18:37
Subject: Re: Oracle MINUS is not supported

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group