Re: add label to enum syntax

Pavel Golub <pavel@microolap.com>

From: Pavel Golub <pavel@microolap.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-10-28T10:49:48Z
Lists: pgsql-hackers
Hello, Andrew.

You wrote:


AD> It occurred to me in the dead of the night that instead of:

AD>     ALTER TYPE enumtype ADD 'newlabel'


AD> it might be better to have:

AD>     ALTER TYPE enumtype ADD LABEL 'newlabel'


AD> That way if we later wanted to support some other sort of ADD operation
AD> on types we would be able to more easily. LABEL is already a keyword, so
AD> it should be pretty minimally invasive to make this change, and if we 
AD> want to do it now is the time.

AD> Thoughts?

AD> cheers

AD> andrew


I'm with you.

BTW, I wrote post with poll about this.

-- 
With best wishes,
 Pavel                          mailto:pavel@gf.microolap.com