On Mon, August 23, 2010 11:49 am, Alvaro Herrera wrote: > Excerpts from Andrew Dunstan's message of lun ago 23 05:35:09 -0400 2010: > >> To add a label at the end of the list, do: >> >> ALTER TYPE myenum ADD 'newlabel'; >> >> To add a label somewhere else, do: >> >> ALTER TYPE myenum ADD 'newlabel' BEFORE 'existinglabel'; >> >> or >> >> ALTER TYPE myenum ADD 'newlabel' AFTER 'existinglabel'; > > What do you need AFTER for? Seems to me that BEFORE should be enough. > (You already have the unadorned syntax for adding an item after the last > one, which is the corner case that BEFORE alone doesn't cover). >
You're right. Strictly speaking we don't need it. But it doesn't hurt much to provide it for a degree of symmetry. 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