On Mon, Aug 23, 2010 at 11:49:41AM -0400, 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).
Making things easier for the users is a good thing all by itself :) +1 for including both BEFORE and AFTER. Would it be worth it to allow something like FIRST and LAST? ALTER TYPE myenum ADD 'newlabel' FIRST; ALTER TYPE myenum ADD 'newlabel' LAST; Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers