[postgis-tickets] [PostGIS] #3417: parse_address add example of using with a table of addresses

[PostGIS]

#3417: parse_address add example of using with a table of addresses
---------------------------+---------------------------
 Reporter:  robe           |      Owner:  robe
     Type:  defect         |     Status:  new
 Priority:  medium         |  Milestone:  PostGIS 2.3.0
Component:  documentation  |    Version:  2.2.x
 Keywords:                 |
---------------------------+---------------------------
 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;
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3417>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.