Skip site navigation (1) Skip section navigation (2)

Re: ANSI Standard

From: Steve Midgley <public(at)misuse(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: ANSI Standard
Date: 2008-06-26 19:19:11
Message-ID: 20080626191924.24DEC650E99@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-sql
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

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


Responses

pgsql-sql by date

Next:From: MontaseriDate: 2008-06-26 20:17:13
Subject: Re: ANSI Standard
Previous:From: Marc MaminDate: 2008-06-26 15:06:14
Subject: Re: dynamic events categorization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group