On Mon, August 23, 2010 3:20 pm, Heikki Linnakangas wrote: > On 23/08/10 22:06, Tom Lane wrote: >> Thom Brown<[email protected]> writes: >>> On 23 August 2010 19:25, Joseph Adams<[email protected]> >>> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
