> I see your points. So how is the best way to implement this type of "set" idea
> in something like postgres? Say I have a column named primary colors, and I
> want to limit this to red, blue, and yellow. How is the best way to do this
> without a mysql set?
CREATE TABLE foo (
color varchar(255) NOT NULL,
CHECK (color IN ('red', 'blue', 'yellow'))
};
Chris