Re: ANSI Standard - Mailing list pgsql-sql
| From | Steve Midgley |
|---|---|
| Subject | Re: ANSI Standard |
| Date | |
| Msg-id | [email protected] Whole thread Raw |
| In response to | ANSI Standard ("Pascal Tufenkji" <[email protected]>) |
| Responses | Re: ANSI Standard |
| List | pgsql-sql |
At 02:20 AM 6/25/2008, [email protected] wrote: >Date: Tue, 24 Jun 2008 17:33:11 +0300 >From: "Pascal Tufenkji" <[email protected]> >To: <[email protected]> >Subject: ANSI Standard >Message-ID: <[email protected]> > >Hi, > > > >How do I know if a function (or a certain sql syntax) in Postgres is a >SQL >ANSI Standard, hence it works on all databases such as MySQL, SQL >Server, >Oracle. In general, I find that the Pg docs pretty clear state what is ANSI standard and what isn't within Pg. You can also view the ANSI-92 standard here: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt In terms of making sure you're cross platform compatible, I'd say you have to designate a series of platforms (e.g. MySQL 5, Pg 8.3, Oracle X, MS SQL X, ext) which you will test against and explicitly support. You will find that no matter how tightly you attempt to build your platform against ANSI-92 (or any other std) if you do not regularly test against a set of platforms, your solution will converge on supporting only the platforms you do regular test against. I hope that helps, Steve