Re: How to modify ENUM datatypes?

[Andrew Sullivan <ajs(at)crankycanuck(dot)ca>]

On Wed, Apr 23, 2008 at 07:46:07PM -0400, brian wrote:
> 
> Absolutely true. Which is odd, because this example is trotted out 
> whenever there's a thread about ENUMs.

I don't think it's odd at all.  In my view, the people who think enums are a
good datatype for databases are exactly the sorts who'd think that their
data is as static as this poor understanding of the vagaries of individuals'
sex (gender is a different problem, given its association with social roles)
would suggest.

The world moves around in unexpected ways.  Your data model needs to
accommodate itself to the world, because the alternative is not going to
happen.

A