[HACKERS] Standards URL's
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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [HACKERS] 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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Standards URL's
Bruce Momjian <[EMAIL PROTECTED]> 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
Re: [HACKERS] Standards URL's
In one of the emails I deleted from my mailbox, the person stated they are identical, except in price. > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [HACKERS] Standards URL's
Bruce Momjian <[EMAIL PROTECTED]> 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
Re: [HACKERS] 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