Here are the URL's for the SQL standards.  Where should these go?  Are
they legal?


http://www.ansi.org
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
ftp://gatekeeper.dec.com/pub/standards/sql
ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/

ANSI PDF $20
ISO  PDF $310

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

Thu, 18 Jan 2001 23:54:52 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Standards URL's
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Here are the URL's for the SQL standards.  Where should these go?  Are
> they legal?

> http://www.ansi.org
> http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
> ftp://gatekeeper.dec.com/pub/standards/sql
> ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/

> ANSI PDF $20
> ISO  PDF $310

The document at CMU is a draft version of SQL92, which is legal to
distribute free AFAIK (at least that's been ISO's practice with other
draft standards).  The documents at DEC are some intermediate version
that is probably best ignored.  The documents at umassd are SQL99, and
not marked as drafts; if they are final text then they might well be
considered pirate copies by ISO.  But more likely they are late drafts.

Of course, ANSI will be happy to sell you a certifiably legal copy.

What I want to know is what's the difference between the "ANSI" and
"ISO" PDF versions that ANSI sells, other than a factor of 15 in price?
I sent an email inquiry about that to ANSI a month ago, and have not
gotten an answer.  Anyone know?

			regards, tom lane

Fri, 19 Jan 2001 00:14:22 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Standards URL's 
In one of the emails I deleted from my mailbox, the person stated they
are identical,�except in price.

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Here are the URL's for the SQL standards.  Where should these go?  Are
> > they legal?
> 
> > http://www.ansi.org
> > http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
> > ftp://gatekeeper.dec.com/pub/standards/sql
> > ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/
> 
> > ANSI PDF $20
> > ISO  PDF $310
> 
> The document at CMU is a draft version of SQL92, which is legal to
> distribute free AFAIK (at least that's been ISO's practice with other
> draft standards).  The documents at DEC are some intermediate version
> that is probably best ignored.  The documents at umassd are SQL99, and
> not marked as drafts; if they are final text then they might well be
> considered pirate copies by ISO.  But more likely they are late drafts.
> 
> Of course, ANSI will be happy to sell you a certifiably legal copy.
> 
> What I want to know is what's the difference between the "ANSI" and
> "ISO" PDF versions that ANSI sells, other than a factor of 15 in price?
> I sent an email inquiry about that to ANSI a month ago, and have not
> gotten an answer.  Anyone know?
> 
> 			regards, tom lane
> 


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

Fri, 19 Jan 2001 00:23:41 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Standards URL's
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> In one of the emails I deleted from my mailbox, the person stated they
> are identical,�except in price.

That's what I kinda suspected, but I'd like to see an authoritative
statement.  Who was this person?

			regards, tom lane

Fri, 19 Jan 2001 00:38:04 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Standards URL's 
Tom Lane wrote:
> 
> 
> What I want to know is what's the difference between the "ANSI" and
> "ISO" PDF versions that ANSI sells, other than a factor of 15 in price?
> I sent an email inquiry about that to ANSI a month ago, and have not
> gotten an answer.  Anyone know?
>
IIRC the SQL92 drafts had in every second paragraph notions about 
"not in ANSI" and "not in ISO" so maybe 5% of things were different.

I hope that they have been able to agree on more things since.

---------------
Hannu

Fri, 19 Jan 2001 11:12:06 +0000
Hannu Krosing <hannu@tm.ee>
Re: Standards URL's

I have just added the following developer's FAQ item.  The SQL99 URL in
the attached email, ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/,
is not longer active so I did not mention it.


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


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://www.ansi.org/. The main standards document
is ANSI/ISO/IEC 9075-2-1999.

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:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Here are the URL's for the SQL standards.  Where should these go?  Are
> > they legal?
> 
> > http://www.ansi.org
> > http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
> > ftp://gatekeeper.dec.com/pub/standards/sql
> > ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/
> 
> > ANSI PDF $20
> > ISO  PDF $310
> 
> The document at CMU is a draft version of SQL92, which is legal to
> distribute free AFAIK (at least that's been ISO's practice with other
> draft standards).  The documents at DEC are some intermediate version
> that is probably best ignored.  The documents at umassd are SQL99, and
> not marked as drafts; if they are final text then they might well be
> considered pirate copies by ISO.  But more likely they are late drafts.
> 
> Of course, ANSI will be happy to sell you a certifiably legal copy.
> 
> What I want to know is what's the difference between the "ANSI" and
> "ISO" PDF versions that ANSI sells, other than a factor of 15 in price?
> I sent an email inquiry about that to ANSI a month ago, and have not
> gotten an answer.  Anyone know?
> 
> 			regards, tom lane
> 

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

Wed, 17 Apr 2002 01:01:38 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Standards URL's