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@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
