Re: Where to get official SQL spec (was Re: Domain Support)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rod Taylor <rbt(at)zort(dot)ca>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Where to get official SQL spec (was Re: Domain Support)
Date: 2002-04-17 05:16:07
Message-ID: 200204170516.g3H5G8G12417@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


I have updated the developer's FAQ with this information:

---------------------------------------------------------------------------

1.12) Where can I get a copy of the SQL standards?

There are two pertinent standards, SQL92 and SQL99. These standards are
endorsed by ANSI and ISO. A draft of the SQL92 standard is available at
http://www.contrib.andrew.cmu.edu/~shadow/. The SQL99 standard must be
purchased from ANSI at
http://webstore.ansi.org/ansidocstore/default.asp. The main standards
documents are ANSI X3.135-1992 for SQL92 and ANSI/ISO/IEC 9075-2-1999
for SQL99.

A summary of these standards is at
http://dbs.uni-leipzig.de/en/lokal/standards.pdf and
http://db.konkuk.ac.kr/present/SQL3.pdf.

---------------------------------------------------------------------------

Tom Lane wrote:
> "Rod Taylor" <rbt(at)zort(dot)ca> writes:
> > I've not found a cheap resource for the real one. Ie. priced suitably
> > to fit a hobby project :)
>
> Try ANSI's electronic standards store: they'll sell you PDFs of ANSI's
> printing of the spec at a reasonable price.
>
> http://webstore.ansi.org/ansidocstore/default.asp
>
> Go to the "search" page and enter "9075" (the IS number for SQL).
> Along with the overpriced ISO offerings, there are:
>
> ANSI X3.135-1992 SQL92
>
> ANSI/ISO/IEC 9075-n-1999 SQL99, parts 1-5
>
> Each of these is $18 US. You don't really need all five parts of
> SQL99; I've seldom found any use for anything but part 2. It is
> worth having SQL92, mainly because it's so much more readable
> than the 99 spec :-(
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2002-04-17 05:26:24 Re: Index Scans become Seq Scans after VACUUM ANALYSE
Previous Message Bruce Momjian 2002-04-17 05:06:22 Re: Index Scans become Seq Scans after VACUUM ANALYSE

Browse pgsql-patches by date

  From Date Subject
Next Message John Proctor 2002-04-17 06:22:14 Re: [SQL] 16 parameter limit
Previous Message Bruce Momjian 2002-04-17 02:10:37 Re: ANSI Compliant Inserts