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

Re: SQL 2003 conformance

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Troels Arvin <troels(at)arvin(dot)dk>, pgsql-docs(at)postgresql(dot)org
Subject: Re: SQL 2003 conformance
Date: 2004-10-21 12:20:49
Message-ID: 200410211420.49940.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-docs
Troels Arvin wrote:
> An obvious question is how strict to be:

Very strict.  SQL is a standard, not a guideline.  If you can't type in 
what it says, then it's not supported.

We make occasional exceptions in extreme cases.  For example, we claim 
to support aliases in the select list (E051-05), but we require the AS.  
It would be unhelpful if we instead wrote that we don't support select 
list aliases.  But a comment should be added in these cases.

The other exception is that because of additional features that 
PostgreSQL provides, some standard features may be restricted.  
Additional reserved key words are an obvious example.  But that is 
allowed by the SQL standard.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


In response to

pgsql-docs by date

Next:From: Josh BerkusDate: 2004-10-21 16:35:03
Subject: Re: SQL 2003 conformance
Previous:From: Viktor VislobokovDate: 2004-10-21 04:25:51
Subject: Updated version of FAQ_russian.html

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