"Ben Edwards" <funkytwig@xxxxxxxxx> 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 implements all and only what is in the spec. Exhibit A in this regard is that the standard refuses to specify any user-visible index manipulation; so the moment you write anything like CREATE INDEX you are on implementation-dependent ground. regards, tom lane
