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

From: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Date: 2007-09-28 09:25:44
Message-ID: 55A0B3C8-2A07-45C3-BB18-27A88C67EF28@grid.unep.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2007-09-28 10:16:54 Re: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
Previous Message Nis Jørgensen 2007-09-28 09:24:17 Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?