[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.
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
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