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?  (Ben Chobot <bench@silentmedia.com>)
Список pgsql-general
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"
Дата:
Сообщение: Unnecessary scan on a partial index slows down query dramatically