Re: add label to enum syntax

Alex Hunsaker <badalex@gmail.com>

From: Alex Hunsaker <badalex@gmail.com>

To: Alvaro Herrera <alvherre@commandprompt.com>

Cc: Andrew Dunstan <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>, Dean Rasheed <dean.a.rasheed@gmail.com>, "David E. Wheeler" <david@kineticode.com>, Robert Haas <robertmhaas@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2010-10-27T16:58:38Z

Lists: pgsql-hackers

On Wed, Oct 27, 2010 at 08:57, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
articular direction.  Now *this* is proper bikeshedding.
>
> Should we ask more openly in another thread, with a different, more
> catchy subject?

Wait you want more bikeshedding? :P Anyway If I look at the original concern:

>> ...instead of:
>>  ALTER TYPE enumtype ADD 'newlabel'
>> it might be better to have:
>> ALTER TYPE enumtype ADD LABEL 'newlabel'
>> That way if we later wanted to support some other sort of ADD operation on types we would be able to more easily.

I have not seen anyone suggest what those other add operations might
be.  Maybe the thing to-do is leave it alone.  That is naked ADD,
neither VALUE or LABEL.

However, in the interest of progress-- +1 for VALUE;  Its how I
naturally tried to "do it" in psql.