On Mon, August 23, 2010 3:20 pm, Heikki Linnakangas wrote: > On 23/08/10 22:06, Tom Lane wrote: >> Thom Brown<t...@linux.com> writes: >>> On 23 August 2010 19:25, Joseph Adams<joeyadams3.14...@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. >
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
