Re: How to modify ENUM datatypes?

On Thu, Apr 24, 2008 at 12:22 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
> The first time I encountered them, I thought enums were a filthy,
> ill-conceived answer to a problem that didn't exist, implemented by people
> who didn't understand relational databases. With considerably more
> experience under my belt than then, I say now that my original estimation
> was too kind.

I think you're being a little too hard on enums here. I was actually
in the anti-enum camp until it was demonstrated to me (and in my own
testing) that using enum for natural ordering vs. fielding the
ordering of the type out to a join is can be a huge win in such cases
where it is important. Relational theory is all well and good, but in
practical terms things like record size, index size, and query
performance are important.

I'll admit that if computers were infinitely fast, I'd probably use
enums less, although I still like them for things like male/female. I
think they have a place.

The difficulty of manipulating enums is simply a shortcoming of the
implementation which could presumably be solved at some later point.

merlin