From: | Montaseri <montaseri(at)gmail(dot)com> |
---|---|
To: | "Steve Midgley" <public(at)misuse(dot)org> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: ANSI Standard |
Date: | 2008-06-26 20:17:13 |
Message-ID: | 8078a1730806261317y5ae55147saa3e2a6b43d968f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
- 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(at)misuse(dot)org> wrote:
> At 02:20 AM 6/25/2008, pgsql-sql-owner(at)postgresql(dot)org wrote:
>
>> Date: Tue, 24 Jun 2008 17:33:11 +0300
>> From: "Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb>
>> To: <pgsql-sql(at)postgresql(dot)org>
>> Subject: ANSI Standard
>> Message-ID: <000601c8d607$3acda550$150fa8c0(at)interne(dot)usj(dot)edu(dot)lb>
>>
>> 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 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tarlika Elisabeth Schmitz | 2008-06-26 23:35:38 | exclude part of result |
Previous Message | Steve Midgley | 2008-06-26 19:19:11 | Re: ANSI Standard |