Re: extracting location info from string

From: Tarlika Elisabeth Schmitz <postgresql3(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: extracting location info from string
Date: 2011-05-22 22:00:41
Message-ID: 20110522230041.28d1bc35@dick.coachhouse
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, 22 May 2011 21:05:26 +0100
Tarlika Elisabeth Schmitz <postgresql3(at)numerixtechnology(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrej 2011-05-23 01:11:24 Re: extracting location info from string
Previous Message Tarlika Elisabeth Schmitz 2011-05-22 20:05:26 extracting location info from string