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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html