HowTo divide streetname from house-nr ?

Поиск
Список
Период
Сортировка
От Andreas
Тема HowTo divide streetname from house-nr ?
Дата
Msg-id 4C9AAC85.1000001@gmx.net
обсуждение исходный текст
Ответы Re: HowTo divide streetname from house-nr ?  (Craig Ringer <craig@postnewspapers.com.au>)
Re: HowTo divide streetname from house-nr ?  (negora <negora@negora.com>)
Список pgsql-sql
  Hi,

how could I divide streetnames from housenumbers ?

I have to deal with input like this:

Parkstreet 42
Parkstr. 42
Casle Avenue 42
Casle Str. 42-47
Casle Str. 54 - 55

probaply even
Casle Str. 42-47 a

Perhaps one could cut ap the 1st numeric char and regard everything left 
of it as the street name and the rest as house number.
OK, this would fail with "42, Parkstreet" but those aren't to frequent.

How would I do this?


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Steve"
Дата:
Сообщение: Re: Question about PQexecParams
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: HowTo divide streetname from house-nr ?