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