Re: WIP: extensible enums

On Mon, August 23, 2010 3:20 pm, Heikki Linnakangas wrote:
> On 23/08/10 22:06, Tom Lane wrote:
>> Thom Brown  writes:
>>> On 23 August 2010 19:25, Joseph Adams
>>> wrote:
>>>> But what if you want to insert an OID at the end?
>>
>>> ALTER TYPE colors ADD 'orange';
>>
>> Alternatively, if people are dead set on symmetry, what we should do
>> to simplify is drop *this* syntax, and just have the BEFORE and AFTER
>> variants.
>
> Then you need to know the last existing value to add a new one to the
> end. Seems awkward.
>

I agree. This is a non-starter, I think. The most common case in my
experience is where the user doesn't care at all about the order, and just
wants to add a new label. We should make that as easy as possible,
especially since it's the most efficient.

cheers

andrew