Re: Oracle MINUS is not supported

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Denis Perchine <dyp(at)perchine(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Oracle MINUS is not supported
Date: 2001-03-10 15:09:26
Message-ID: 200103101509.KAA16064@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Ultimlately, what we would like is a pre-grammar to convert Oracle-isms
to PostgreSQL/ANSI.

[ Charset KOI8-R unsupported, converting... ]
> Hello,
>
> Oracle has MINUS keyword used instead of EXCEPT.
> I know that this sucks, but I like sometimes to test Oracle queries on
> PostgreSQL (I should use Oracle...).
>
> Here is a patch to make minus working same way as except. I am not sure it is
> complety correct (I am not very big guru in grammars... Just wrote draft
> version of Oberon-2 -> C++ translator). Please someone more expirienced check
> that all is fine.
>
> BTW, I am not ask for inclusion in current tree. I just create a patch, and
> if someone need it it can be picked up.
>
> --
> Sincerely Yours,
> Denis Perchine
>
> ----------------------------------
> E-Mail: dyp(at)perchine(dot)com
> HomePage: http://www.perchine.com/dyp/
> FidoNet: 2:5000/120.5
> ----------------------------------

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Denis Perchine 2001-03-10 15:13:23 Re: Oracle MINUS is not supported
Previous Message Denis Perchine 2001-03-10 14:20:26 Oracle MINUS is not supported