[Tagging] football or soccer ?

Anthony osm at inbox.org
Mon Aug 2 16:28:34 BST 2010


On Mon, Aug 2, 2010 at 10:56 AM, Anthony <osm at inbox.org> 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.



More information about the Tagging mailing list