Thread: Re: [PATCHES] Domain Support -- another round
> > Not entirely sure, except the book I had (SQL99 Complete, Really) > > specifically forbids it. > > > > Yes, but this is their interpretation of the standard. There is an Understood. It's the best that I had on me. I've not found a cheap resource for the real one. Ie. priced suitably to fit a hobby project :) > error in that page anyway, as the standard explicitly forbids > arrays and UDTs and they list REF and ARRAY as valid data types. > (they also get confused with SESSION_USER and CURENT_USER on page > 281, so it does not surprise me).
"Rod Taylor" <rbt@zort.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
> "Rod Taylor" <rbt@zort.ca> writes: > > I've not found a cheap resource for the real one. Ie. priced suitably > > to fit a hobby project :) I seem to have parts 1-5 .txt of sql99 on my computer here. I ftp'd them off some ftp site yonks ago. Anyone want them? Is it legal for me to have them or distribute them? Chris
Christopher Kings-Lynne wrote: > > "Rod Taylor" <rbt@zort.ca> writes: > > > I've not found a cheap resource for the real one. Ie. priced suitably > > > to fit a hobby project :) > > I seem to have parts 1-5 .txt of sql99 on my computer here. I ftp'd them > off some ftp site yonks ago. Anyone want them? Is it legal for me to have > them or distribute them? I have these URL's: > 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/ -- 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, Pennsylvania19026
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> I seem to have parts 1-5 .txt of sql99 on my computer here. I ftp'd them
> off some ftp site yonks ago. Anyone want them? Is it legal for me to have
> them or distribute them?
My understanding of the legal situation is that what's circulating
around the net in plain text form is *draft* versions of the spec.
It is okay to redistribute these freely. The *official* version
you are supposed to pay for.
No, I don't know how close the drafts really are to the final.
Personally I tend to consult the draft versions more than the PDF
versions anyway, because it's vastly easier to search flat ASCII
files than PDFs ... so I sure hope they're pretty close ...
regards, tom lane
It would be nice to add it to the docs of the project. ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> Cc: "Rod Taylor" <rbt@zort.ca>; "Hackers List" <pgsql-hackers@postgresql.org> Sent: Friday, March 22, 2002 1:29 PM Subject: Re: [HACKERS] Where to get official SQL spec (was Re: Domain Support) > "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes: > > I seem to have parts 1-5 .txt of sql99 on my computer here. I ftp'd them > > off some ftp site yonks ago. Anyone want them? Is it legal for me to have > > them or distribute them? > > My understanding of the legal situation is that what's circulating > around the net in plain text form is *draft* versions of the spec. > It is okay to redistribute these freely. The *official* version > you are supposed to pay for. > > No, I don't know how close the drafts really are to the final. > > Personally I tend to consult the draft versions more than the PDF > versions anyway, because it's vastly easier to search flat ASCII > files than PDFs ... so I sure hope they're pretty close ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
> It would be nice to add it to the docs of the project.
If anyone wants a copy, just holler. A bunch of us have exchanged those
drafts over the years so speak up and someone will forward you a copy...
I'm sure we stumbled on them via google or somesuch so a quick search
would get you an independent copy too...
- Thomas
Thomas Lockhart wrote: > > It would be nice to add it to the docs of the project. > > If anyone wants a copy, just holler. A bunch of us have exchanged those > drafts over the years so speak up and someone will forward you a copy... > > I'm sure we stumbled on them via google or somesuch so a quick search > would get you an independent copy too... Should I add the URL's to the developer's FAQ? -- 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, Pennsylvania19026
Does it mean that we are not 100% sure they are open documents? ----- Original Message ----- From: "Thomas Lockhart" <thomas@fourpalms.org> To: "Nicolas Bazin" <nbazin@ingenico.com.au> Cc: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>; "Tom Lane" <tgl@sss.pgh.pa.us>; "Rod Taylor" <rbt@zort.ca>; "Hackers List" <pgsql-hackers@postgresql.org> Sent: Friday, March 22, 2002 3:36 PM Subject: Re: Where to get official SQL spec (was Re: Domain Support) > > It would be nice to add it to the docs of the project. > > If anyone wants a copy, just holler. A bunch of us have exchanged those > drafts over the years so speak up and someone will forward you a copy... > > I'm sure we stumbled on them via google or somesuch so a quick search > would get you an independent copy too... > > - Thomas >
> Does it mean that we are not 100% sure they are open documents?
Hmm. Yeah, though afaics there is no copyright inside the docs.
- Thomas
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@zort.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@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026