Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group