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

Reply via email to