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

Re: add label to enum syntax

From: Brendan Jurd <direvus(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add label to enum syntax
Date: 2010-10-27 16:41:53
Message-ID: AANLkTimm+8E3htmNhh7OY3sFHnJbhH==jXLS8Apd0uLM@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 26 October 2010 02:48, Andrew Dunstan <andrew(at)dunslane(dot)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

In response to

pgsql-hackers by date

Next:From: Alex HunsakerDate: 2010-10-27 16:58:38
Subject: Re: add label to enum syntax
Previous:From: David E. WheelerDate: 2010-10-27 16:24:41
Subject: Re: Bikeshedding on enum vocabulary

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