[Tagging] football or soccer ?
John F. Eldredge
john at jfeldredge.com
Mon Aug 2 17:56:36 BST 2010
Well, in this particular case, the issue was regional preferences about whether to call a particular game football, association football, soccer, etc., and the reason for using a link to an associated table was so that multiple names could map to the same field value.
-------Original Email-------
Subject :Re: [Tagging] football or soccer ?
From :mailto:osm at inbox.org
Date :Mon Aug 02 10:28:34 America/Chicago 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.
_______________________________________________
Tagging mailing list
Tagging at openstreetmap.org
http://lists.openstreetmap.org/listinfo/tagging
--
John F. Eldredge -- john at jfeldredge.com
"Reserve your right to think, for even to think wrongly is better than not to think at all." -- Hypatia of Alexandria
More information about the Tagging
mailing list