Re: Oracle MINUS is not supported

On Saturday 10 March 2001 22:18, Tom Lane wrote:
> Denis Perchine <dyp@perchine.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@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------