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.
regards, tom lane
