Обсуждение: sql99 / sql3

Поиск
Список
Период
Сортировка

sql99 / sql3

От
Ron Peterson
Дата:
I just recieved SQL in a Nutshell from O'Reilly.  I bought the book
because it covers the SQL99 standard.  It's my understanding that this
is the most recent SQL standard.  Am I correct about this?  What is the
current status of SQL standards?  What is the most recent approved
standard, and what aspects of SQL are still under discussion?

I ask, because I notice that the book doesn't mention recursive unions. 
In fact I don't see mention of unions at all, nevermind recursive
unions, so this may simply be an oversight.  However, since this is a
feature I've really been looking forward to, I'm now wondering if I'm
hoping in vain.

What organization is currently responsible for drafting SQL standards? 
How can I obtain publications describing those standards?  Is there
anything comprehensive and definitive online?

-Ron-


Re: sql99 / sql3

От
Tom Lane
Дата:
Ron Peterson <ron.peterson@yellowbank.com> writes:
> What organization is currently responsible for drafting SQL standards? 

ISO.

> How can I obtain publications describing those standards?  Is there
> anything comprehensive and definitive online?

In the US you can buy ISO standards from ANSI, see
http://webstore.ansi.org/ansidocstore/default.asp

The documents you want are ISO 9075-nnn.  The ANSI price list shows
two sets, ISO/IEC 9075-n:1999 and ANSI/ISO/IEC 9075-n-1999.  The
difference between them is not obvious (except for the huge price
differential!?).  I've been trying to find out what the difference
is, if any, but no luck yet.
        regards, tom lane