Re: Writing oracle/postgress generic SQL

On Fri, Feb 23, 2007 at 10:23:56AM +0100, Ben Edwards wrote:
> Anyone know of any guidelines for writing SQL which works under
> Oracle witch will also work under postgress. This is to ensure that
> SQL written for an Oracle database can be migrated to postgress
> later.

You've just bumped into the problem that while standard SQL exists,
only Mimer and possibly DB2 implement it. The presentation below
outlines your main choices for supporting more than one DB back-end,
and they're all expensive and troublesome to maintain.

http://www.powerpostgresql.com/Downloads/database_depends_public.swf

The cheapest, highest-quality thing to do is to choose one DB back-end
and then use everything it has to offer.

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!