Skip site navigation (1) Skip section navigation (2)

Re: SQL keywords

From: Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org>
To: pgsql-docs(at)postgresql(dot)org
Subject: Re: SQL keywords
Date: 2000-12-16 08:47:58
Message-ID: 20001216.8475800@aleph.bacbuc.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-docs
Hi !

>>>>>>>>>>>>>>>>>> Message d'origine <<<<<<<<<<<<<<<<<<

Le 12/16/00, à 9:14:16 AM h, hannu(at)tm(dot)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


In response to

pgsql-docs by date

Next:From: Peter EisentrautDate: 2000-12-16 18:29:53
Subject: Re: SQL keywords
Previous:From: Hannu KrosingDate: 2000-12-16 08:08:48
Subject: Re: SQL keywords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group