Re: SQL:2003 keyword additions

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: SQL:2003 keyword additions
Дата
Msg-id 200411241540.08494.peter_e@gmx.net
обсуждение исходный текст
Ответ на SQL:2003 keyword additions  (Simon Riggs <simon@2ndquadrant.com>)
Список 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/

В списке pgsql-patches по дате отправления:

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Re: SQL:2003 keyword additions
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: SQL:2003 keyword additions