Horton

Re: WIP: extensible enums

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thom Brown <thom@linux.com>, Joseph Adams <joeyadams3.14159@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, Alvaro Herrera <alvherre@commandprompt.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-08-23T19:20:15Z
Lists: pgsql-hackers 
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