Re: add label to enum syntax

Brendan Jurd <direvus@gmail.com>

From: Brendan Jurd <direvus@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-10-27T16:41:53Z
Lists: pgsql-hackers
On 26 October 2010 02:48, Andrew Dunstan <andrew@dunslane.net> wrote:
>
> It occurred to me in the dead of the night that instead of:
>
>   ALTER TYPE enumtype ADD 'newlabel'
>
> it might be better to have:
>
>   ALTER TYPE enumtype ADD LABEL 'newlabel'
>
>

It's a real shame we can't have

ALTER ENUM works ADD spanner;

That way it wouldn't matter whether you think of 'spanner' as a
label/value/item/element/thingy.

Cheers,
BJ