At 02:20 AM 6/25/2008, pgsql-sql-owner@[EMAIL PROTECTED]
wrote:
>Date: Tue, 24 Jun 2008 17:33:11 +0300
>From: "Pascal Tufenkji" <ptufenkji@[EMAIL PROTECTED]
>
>To: <pgsql-sql@[EMAIL PROTECTED]
>
>Subject: ANSI Standard
>Message-ID: <000601c8d607$3acda550$150fa8c0@[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 sup****t.
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
sup****ting only the platforms you do regular test against.
I hope that helps,
Steve
--
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
|
