[postgis-users] Various ways to handle addresses in postgresql

[Shaozhong SHI]

I find this is a simple, but important question.

How best to split numbers and the rest of address?

For instance, one tricky one is as follows:

21-1 Great Avenue, a city, a country, this planet

How to turn this into the following:

column 1,       column 2

  21-1              Great Avenue, a city, a country, this planet

Note:  there is a hyphen in  21-1

Any clue?

Regards,

Shao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200425/906150e6/attachment.html>