Re: extracting location info from string - Mailing list pgsql-sql

On Sun, 22 May 2011 21:05:26 +0100
Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de> wrote:

>A column contains location information, which may contain any of the
>following:
>
>1) null
>2) country name (e.g. "France")
>3) city name, region name (e.g. "Bonn, Nordrhein-Westfalen")
>4) city name, Rg. region name (e.g. "Frankfurt, Rg. Hessen")
>5) city name, Rg region name (e.g. "Frankfurt, Rg Hessen")


I also need to cope with variations of COUNTRY.NAME and REGION.NAME.