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

Re: SQL:2003 keyword additions

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 (view raw or flat)
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/

In response to

pgsql-patches by date

Next:From: Simon RiggsDate: 2004-11-24 21:00:56
Subject: Re: SQL:2003 keyword additions
Previous:From: Thomas HallgrenDate: 2004-11-24 11:32:52
Subject: Re: SQL:2003 keyword additions

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