| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Thomas Hallgren <thhal(at)mailblocks(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org, Troels Arvin <troels(at)arvin(dot)dk> |
| Subject: | Re: SQL:2003 keyword additions |
| Date: | 2004-11-24 14:40:08 |
| Message-ID: | 200411241540.08494.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Thomas Hallgren wrote:
> One might argue that it will prevent current PostgreSQL users from
> unintentionally using those keywords and thereby obtain 2 goals:
>
> 1. The SQL code will be more portable since other databases may
> recognize the keywords.
> 2. Migration to a future PostgreSQL version where the relevant
> commands has been implemented will be easier.
There is, however, little to no evidence that any other SQL
implementation reserves those key words or that a future PostgreSQL
feature addition would have to reserve them.
Advising users of possibly unportable features is a valid goal, but it
is best solved as part of the SQL flagger feature that prints out
warnings for all extensions, not just some key words. Various
discussions about the SQL flagger are in the archive.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2004-11-24 21:00:56 | Re: SQL:2003 keyword additions |
| Previous Message | Thomas Hallgren | 2004-11-24 11:32:52 | Re: SQL:2003 keyword additions |