Re: ENUM type

On Tue, Jul 26, 2005 at 03:30:11PM -0700, Josh Berkus wrote:
> > That's a good idea for a stop-gap, or if no one wants to put the effort
> > into creating a useful enum type.
>
> I'm personally not convinced that ENUM *is* useful.

ENUM as MySQL does it, or as something that consolodates the many steps
involved in setting up a simple normalized view for a field that
provides automatic mapping so that the application thinks it's just
dealing with a text/varchar? ISTM that given how common the use case is
and the non-trivial amount of code involved that it's worth attempting.
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"