On Mon, Aug 2, 2010 at 10:56 AM, Anthony <[email protected]> wrote: > If I wanted the list of colors to be controlled and > finite I'd use a check constraint.
By the way, if I were going to use a separate table for the list of colors, for instance for performance purposes, I'd still use the name of the color as the key, thus avoiding doing a join every single time you do a select. The lookup would only be necessary when doing adds, in order to check the foreign key constraint. The lookup table on color would have only one column, the color name. _______________________________________________ Tagging mailing list [email protected] http://lists.openstreetmap.org/listinfo/tagging
