parse_address add example of using with a table of addresses
|Reported by:||robe||Owned by:||robe|
Someone mentioned this on IRC:
thread here. I realized that's probably more common use that the example we have in docs, so needs to be added.
<ElizabethAB> I have what I expect to be a simple question. I have a table with an address string, say `table1` with variable `address`. The examples for the `parse_address()` function show passing directly a string, http://postgis.net/docs/parse_address.html. How do I instead pass the variable from the table? <robe2> ElizabethAB: SELECT (a).* FROM (SELECT parse_address(address) As a FROM table1) As foo;