From: Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de>
To: pgsql-sql@postgresql.org
Subject: Re: extracting location info from string
Date: Sun, 22 May 2011 23:00:41 +0100
Message-ID: <20110522230041.28d1bc35@dick.coachhouse> (raw)
In-Reply-To: <20110522210526.0f8b66fa@dick.coachhouse>
References: <20110522210526.0f8b66fa@dick.coachhouse>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql3@numerixtechnology.de
Subject: Re: extracting location info from string
In-Reply-To: <20110522230041.28d1bc35@dick.coachhouse>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox