On Thu, Apr 24, 2008 at 12:22 PM, Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> 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
