Re: How to modify ENUM datatypes?

Поиск
Список
Период
Сортировка
Искать
От
Steve Atkins
Тема
Re: How to modify ENUM datatypes?
Дата
Msg-id
22D5F880-AECF-44AF-B56A-4C35F8D179B7@blighty.com
Ответ на
Список
Дерево обсуждения
Re: How to modify ENUM datatypes? Chris Browne <cbbrowne@acm.org>
Re: How to modify ENUM datatypes? "Scott Marlowe" <scott.marlowe@gmail.com>
Re: How to modify ENUM datatypes? "David Wilson" <david.t.wilson@gmail.com>
Re: How to modify ENUM datatypes? Tom Lane <tgl@sss.pgh.pa.us>
Re: How to modify ENUM datatypes? "Rob Wultsch" <wultsch@gmail.com>
Re: How to modify ENUM datatypes? Andrew Sullivan <ajs@commandprompt.com>
Re: How to modify ENUM datatypes? Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: How to modify ENUM datatypes? Martijn van Oosterhout <kleptog@svana.org>
Re: How to modify ENUM datatypes? Tino Wildenhain <tino@wildenhain.de>
Re: How to modify ENUM datatypes? Andrew Sullivan <ajs@commandprompt.com>

On Apr 25, 2008, at 8:19 AM, Ben Chobot wrote:

>
> On Apr 25, 2008, at 4:49 AM, Giorgio Valoti wrote:
>
>> And reorder them, too.
>
> Why would you want to reorder an enum? It seems to me the point of  
> them is to hold a small list of valid values.  The order the list is  
> described in surely should be irrelevant?

One of the main charms of using an enum for some things is that it has  
a natural ordering.

Critical > Urgent > Normal > Low > Marginal

It's not the only reason to use an enum, but for me it'd be the most  
compelling.

Cheers,
   Steve

В списке pgsql-general по дате отправления
От: andy petrella
Дата:
Сообщение: Full Text Search
От: Jimmy Choi
Дата:
FAQ