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 15:13:23
Message-ID: 01031021132305.00608@dyp.perchine.com (view raw or flat)
Thread:
Lists: pgsql-patches
On Saturday 10 March 2001 21:09, Bruce Momjian wrote:
> Ultimlately, what we would like is a pre-grammar to convert Oracle-isms
> to PostgreSQL/ANSI.

Not sure that I get what do you mean? Could you please be more verbose.

> [ 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

-- 
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

Responses

pgsql-patches by date

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

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