Re: Oracle MINUS is not supported - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Oracle MINUS is not supported
Date
Msg-id 200103101509.KAA16064@candle.pha.pa.us
Whole thread Raw
In response to Oracle MINUS is not supported  (Denis Perchine <dyp@perchine.com>)
Responses Re: Oracle MINUS is not supported  (Denis Perchine <dyp@perchine.com>)
List 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@perchine.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@postgresql.org


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

pgsql-patches by date:

Previous
From: Denis Perchine
Date:
Subject: Oracle MINUS is not supported
Next
From: Denis Perchine
Date:
Subject: Re: Oracle MINUS is not supported