| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
----------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-03-10 17:20:17 | Re: Oracle MINUS is not supported |
| Previous Message | Tom Lane | 2001-03-10 16:18:37 | Re: Oracle MINUS is not supported |