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: <pgsql-sql@postgresql.org>
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
