Re: [PATCHES] Select parser at runtime - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PATCHES] Select parser at runtime
Date
Msg-id Pine.LNX.4.30.0108120217490.734-100000@peter.localdomain
Whole thread Raw
In response to Re: [PATCHES] Select parser at runtime  (Ian Lance Taylor <ian@airs.com>)
Responses Re: Re: [PATCHES] Select parser at runtime
Re: Re: [PATCHES] Select parser at runtime
Re: [PATCHES] Select parser at runtime
List pgsql-hackers
Ian Lance Taylor writes:

> Because my goal is a parser which can accept Oracle code directly, and
> Oracle does not use the same SQL syntax as Postgres.  They are, of
> course, very similar, but it is not the case that all the differences
> are items missing from the Postgres parser.  Some of them are items
> which Postgres does in a different, typically more standards-
> conforming, way.

I'm not sure whether I like the notion of having to maintain multiple
parsers in the future.  We have always been quite fair in accepting
extensions and aliases for compatibility, so I don't see a problem there.
Then again, we're implemented an SQL server, not an Oracle server.  If you
want to convert your application there's this ora2pg thing.

> For example: the datatypes have different names; the set of reserved
> words is different;

Unless you have implemented a different parsing algorithm or want to rip
out features you're going to have a hard time changing the set of reserved
words.

> Oracle uses a weird syntax for outer joins.

We had already rejected this idea.  The earlier this disappears from the
face of the earth the better.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Re: WIN32 errno patch
Next
From: Tom Lane
Date:
Subject: Re: Re: [PATCHES] Select parser at runtime