------=_Part_19202_6081998.1214511433474
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
- Try SQL 2003 standards....92 is way old
- You'll find that even the big boys like Oracle, DB2 etc will diverge
from
SQL standards if they make more $$ thier way...let alone toys like MySQL
and
MS-SQL
Cheers
Medi
On Thu, Jun 26, 2008 at 12:19 PM, Steve Midgley <public@[EMAIL PROTECTED]
> wrote:
> 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<http://www.contrib.andrew.cmu.edu/%7Eshadow/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
>
------=_Part_19202_6081998.1214511433474
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
<br>- Try SQL 2003 standards....92 is way old<br>- You'll find that
even the big boys like Oracle, DB2 etc will diverge from SQL standards if
they make more $$ thier way...let alone toys like MySQL and
MS-SQL<br><br>Cheers<br>
Medi<br><br><div class="gmail_quote">On Thu, Jun 26, 2008 at 12:19 PM,
Steve Midgley <<a
href="mailto:public@[EMAIL PROTECTED]
">public@[EMAIL PROTECTED]
>>
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
At 02:20 AM 6/25/2008, <a href="mailto:pgsql-sql-owner@[EMAIL PROTECTED]
"
target="_blank">pgsql-sql-owner@[EMAIL PROTECTED]
> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Date: Tue, 24 Jun 2008 17:33:11 +0300<br>
From: "Pascal Tufenkji" <<a
href="mailto:ptufenkji@[EMAIL PROTECTED]
"
target="_blank">ptufenkji@[EMAIL PROTECTED]
>><br>
To: <<a href="mailto:pgsql-sql@[EMAIL PROTECTED]
"
target="_blank">pgsql-sql@[EMAIL PROTECTED]
>><br>
Subject: ANSI Standard<br>
Message-ID: <000601c8d607$3acda550$<a
href="mailto:150fa8c0@[EMAIL PROTECTED]
"
target="_blank">150fa8c0@[EMAIL PROTECTED]
>><br>
<br>
Hi,<br>
<br>
<br>
<br>
How do I know if a function (or a certain sql syntax) in Postgres is a
SQL<br>
ANSI Standard, hence it works on all databases such as MySQL, SQL
Server,<br>
Oracle.<br>
</blockquote>
<br>
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:<br>
<br>
<a href="http://www.contrib.andrew.cmu.edu/%7Eshadow/sql/sql1992.txt"
target="_blank">http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt</a><br>
<br>
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.<br>
<br>
I hope that helps,<br>
<br>
Steve<br><font color="#888888">
<br>
<br>
-- <br>
Sent via pgsql-sql mailing list (<a href="mailto:pgsql-sql@[EMAIL PROTECTED]
"
target="_blank">pgsql-sql@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</font></blockquote></div><br>
------=_Part_19202_6081998.1214511433474--
|
