Re: Normalized Tables & SELECT [was: Find "smallest common year"]

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Дата
Msg-id 55A0B3C8-2A07-45C3-BB18-27A88C67EF28@grid.unep.ch
обсуждение исходный текст
Ответ на Re: Normalized Tables & SELECT [was: Find "smallest common year"]  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Nis Jørgensen
Дата:
Сообщение: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?