Re: Normalized Tables & SELECT [was: Find "smallest common year"] - Mailing list pgsql-general

From Stefan Schwarzer
Subject Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Date
Msg-id 55A0B3C8-2A07-45C3-BB18-27A88C67EF28@grid.unep.ch
Whole thread Raw
In response to Re: Normalized Tables & SELECT [was: Find "smallest common year"]  (Richard Huxton <dev@archonet.com>)
List pgsql-general
> Ah, but there is a standardised list of country-codes ideal for the
> DBA since the code is (usually) easily understandable.
>   http://en.wikipedia.org/wiki/ISO_3166
> The only problem might be if historical data uses old boundaries
> (e.g. Soviet Union, Yugoslavia).

Yep, have all of them (ISO-2, ISO-3, UN), but they don't cover all
countries + territories. Nevertheless, in most cases the list is
sufficient...

Thanks nevertheless for the link!

Stef



pgsql-general by date:

Previous
From: Nis Jørgensen
Date:
Subject: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
Next
From: Alban Hertroys
Date:
Subject: Re: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?