Re: Conformance of PostgreSQL to ANSI/ISO Standard

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: J M Sykes <mike(dot)sykes(at)acm(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Conformance of PostgreSQL to ANSI/ISO Standard
Date: 2003-04-13 19:54:45
Message-ID: 3E99C085.4040008@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

J M Sykes wrote:
> I have been looking at
>
> ftp://ftp.be.postgresql.org/postgresql/doc/7.2/reference-7.2-A4.pdf
>
> and on page 70, CREATE TABLE, Compatibility, I find a statement that
> suggests the writer was under a misapprehension.
>
> You say first:
>
> <quote>
> The CREATE TABLE conforms to SQL92 Intermediate and to a subset of SQL99,
> with exceptions listed below and in the descriptions above.

...

> However, none of these conform to SQL:1992 at any level (or to
> the temporary tables feature of SQL:1999), so you're in good
> company, but apparently mistaken.

Yeah. This was the subject of my confusion as well. Tom sorts it
out:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3E28A02C.5090900%40mascari.com&rnum=1&prev=/groups%3Fq%3DMike%2BMascari%2Btemp%2Bglobal%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den

> FYI, though not a member of the ANSI committee, I do contribute to the ISO
> working group.
>
> Mike Sykes.

Mike Mascari

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Mascari 2003-04-13 20:17:46 Re: Conformance of PostgreSQL to ANSI/ISO Standard
Previous Message Hannu Krosing 2003-04-13 19:43:06 Re: Anyone working on better transaction locking?