Re: WIP: extensible enums

On 23/08/10 22:06, Tom Lane wrote:
> Thom Brown<thom@linux.com>  writes:
>> On 23 August 2010 19:25, Joseph Adams<joeyadams3.14159@gmail.com>  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.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com