Gavin Sherry wrote:
> On Sat, 3 Jul 2004, Tom Lane wrote:
>
> > Andreas Pflug <pgadmin@pse-consulting.de> writes:
> > > - what about Oracle portability.
> >
> > > IMHO we should rethink if we could make those people happy. How about a
> > > loadable personality (IIRC SAPDB has something like that), to exchange
> > > the parser in use with a custom one (by a SET command)? This way we have
> > > a pure ansi default, while enabling a way so someone could contribute an
> > > oracle style parser.
> >
> > How about an external tool that helps in translating apps to
> > SQL-standard syntax? Oracle does accept the standard syntax after all.
> > That way we are truly helping people liberate themselves: they can
> > switch to any SQL-compliant database, not only Postgres.
>
> I totally agree. After all, oracle provides such tools to their customers.
Should this be a TODO?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
