I agree, as long as one needs the country names in only one language. -Mark (Sorry Martin- forgot to "Reply to all" the last time) ________________________________________ De : pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] De la part de Martin Gainty Envoyé : 21 avril 2010 16:38 À : wmoran@xxxxxxxxxxxxxxxxx Cc : pgsql-general@xxxxxxxxxxxxxx Objet : Re: Avoiding surrogate keys ... static information such as country names *should be* de-normalised into non-indexed columns of the driving table as you have already done if on the other hand the column information country names were changing were dynamic then you would want to keep them in their respective table as country code 001 will always be US (and the remaining countries and country code will never change) i would suggest keeping the full name in the driving table (same goes with state/province data btw) ... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
