From: Emmanuel Charpentier <charpent@bacbuc.dyndns.org>
To: pgsql-docs@postgresql.org
Subject: Re: SQL keywords
Date: Sat, 16 Dec 2000 08:47:58 GMT
Message-ID: <20001216.8475800@aleph.bacbuc.dyndns.org> (raw)
References: <3A3B2310.EB5C3DEE@tm.ee>
Hi !
>>>>>>>>>>>>>>>>>> Message d'origine <<<<<<<<<<<<<<<<<<
Le 12/16/00, à 9:14:16 AM h, hannu@tm.ee (Hannu Krosing) vous a écrit sur
le sujet suivant Re: [DOCS] SQL keywords:
> Peter Eisentraut wrote:
> >
> > The section on SQL keywords in the User's Guide needs some updating.
> >
> > I figured that I could generate these various lists of reserved and
> > non-reserved keywords automatically --- and indeed I can!
[ bandwidth savings ... ]
> It could be a good thing to have a table of the form
> Keyword | PostgreSQL | SQL 92 | SQL 99 |
> -----------+--------------+-------------+-------------+
> SELECT | Reserved | Reserved | Reserved |
> WITH | - | - | Reserved |
> IN | Yes | - | Reserved |
Hmmm ...
Better make that
Keyword | Standard | Status |
------------+-----------+---------+
SELECT | SQL92 | Reserved|
SELECT | SQL99 | Reserved|
SELECT | PostgreSQL| Reserved|
WITH | SQL92 | Nope |
WITH | SQL99 | Reserved|
WITH | PostgeSQL | Nope |
IN | SQL92 | Nope |
IN | SQL99 | Reserved|
IN | PostgreSQL| Yep |
This form allows for greater flexibility in query/views building. Obvious
drawback : the primary key is composite.
Any thoughts ?
Emmanuel Charpentier
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: charpent@bacbuc.dyndns.org
Subject: Re: SQL keywords
In-Reply-To: <20001216.8475800@aleph.bacbuc.dyndns.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