Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-26 Thread David Fetter
On Mon, Feb 26, 2007 at 08:01:52AM -0800, Richard Troy wrote: > On Fri, 23 Feb 2007, David Fetter wrote: > > On Fri, Feb 23, 2007 at 08:28:06AM -0800, Richard Troy wrote: > > > On Fri, 23 Feb 2007, David Fetter wrote: > > > > On Fri, Feb 23, 2007 at 10:23:56AM +0100, Ben Edwards wrote: > > > > > An

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-26 Thread Joshua D. Drake
>> Unless, as with rare beasties like Science Tools, the >> major purpose of the application is to support multiple DBMS >> back-ends, it's just too expensive. Even in those rare cases, it's >> expensive. > > I guess anything you have to pay for is too expensive. (Sounds like dogma > to me. And

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-26 Thread Richard Troy
On Fri, 23 Feb 2007, David Fetter wrote: > On Fri, Feb 23, 2007 at 08:28:06AM -0800, Richard Troy wrote: > > On Fri, 23 Feb 2007, David Fetter wrote: > > > On Fri, Feb 23, 2007 at 10:23:56AM +0100, Ben Edwards wrote: > > > > Anyone know of any guidelines for writing SQL which works under > > > > O

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread David Fetter
On Fri, Feb 23, 2007 at 08:28:06AM -0800, Richard Troy wrote: > > On Fri, 23 Feb 2007, David Fetter wrote: > > 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

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread SCassidy
Some of the Oracle stuff may differ, depending on version. Susan Cassidy "Ben Edwards" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/23/2007 01:27 AM To pgsql-general@postgresql.org cc Subject [GENERAL] Writing oracle/postgress generic SQL Anyone know of any guidelines

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread Guy Rouillier
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. I converted a fairly complex data collection application from Oracle to

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread Richard Troy
On Fri, 23 Feb 2007, David Fetter wrote: > 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 migrate

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread Tom Lane
"Ben Edwards" <[EMAIL PROTECTED]> writes: > Anyone know of any guidelines for writing SQL which works under Oracle > witch will also work under postgress. The only thing that means anything is testing on both :-(. Yeah, there is a SQL standard, but there is no DBMS anywhere in the world that impl

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread David Fetter
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 t

[GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread Ben Edwards
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. Ben -- Ben Edwards - Brussels, Belgium & Bristol, UK If you have a problem emailing me use ht