From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: extensible enums |
Date: | 2010-08-23 18:13:07 |
Message-ID: | 20100823181307.GA3253@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2010-08-23 18:14:06 | Re: WIP: extensible enums |
Previous Message | Thom Brown | 2010-08-23 18:09:12 | Re: WIP: extensible enums |