Search Postgresql Archives

Re: How to modify ENUM datatypes?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux