"Ben Edwards" <funkytwig(at)gmail(dot)com> 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