Re: How to modify ENUM datatypes? - Mailing list pgsql-general

From Steve Atkins
Subject Re: How to modify ENUM datatypes?
Date
Msg-id 22D5F880-AECF-44AF-B56A-4C35F8D179B7@blighty.com
Whole thread Raw
In response to Re: How to modify ENUM datatypes?  (Ben Chobot <bench@silentmedia.com>)
List 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 by date:

Previous
From: "andy petrella"
Date:
Subject: Full Text Search
Next
From: "Jimmy Choi"
Date:
Subject: Unnecessary scan on a partial index slows down query dramatically