From: David Fetter <david@fetter.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: SQL key word list and SQL:2011
Date: Sun, 20 May 2012 12:28:35 -0700
Message-ID: <20120520192835.GC25017@fetter.org> (raw)
In-Reply-To: <19494.1337527558@sss.pgh.pa.us>
References: <1337450452.10292.11.camel@vanquo.pezone.net>
<19494.1337527558@sss.pgh.pa.us>
On Sun, May 20, 2012 at 11:25:58AM -0400, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > I'm updating the SQL key word list in the appendix. Since there
> > is now SQL:2011, this should be included in the table. But we're
> > running out of horizontal space. We currently have
>
> > Key word | PostgreSQL | SQL:2008 | SQL:2003 | SQL:1999 | SQL-92
>
> > In the PDF, we have space for about 5 columns, and currently the
> > SQL-92 column is already in the margin. If we add one more
> > column, it falls off the page.
>
> > What I'd suggest is that we keep only the SQL:2011 column. The
> > differences from 2003 to 2011 aren't that great that it's very
> > useful to analyze the differences, and 1999 and 1992 are really
> > only of archeological interest. (For example, it's not going to
> > be of any practical relevance to attempt to use a key word that
> > was unreserved in 1999 but reserved later. A number of other
> > vendors will have reserved it by now as well.) We would, however,
> > lose a few key words that were reserved in earlier versions of the
> > standard but then removed (e.g., BIT). Maybe those could be added
> > with a note or something.
>
> Perhaps it'd be useful to keep just SQL-92 and SQL:2011, to give
> some sense of how the standard's keyword set has evolved over time
> while not making the table too wide.
+1 :)
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: david@fetter.org, tgl@sss.pgh.pa.us, peter_e@gmx.net
Subject: Re: SQL key word list and SQL:2011
In-Reply-To: <20120520192835.GC25017@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox