Opened 6 years ago

Closed 6 years ago

#3417 closed defect (fixed)

parse_address add example of using with a table of addresses

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.2.1
Component: documentation Version: 2.2.x
Keywords: Cc:

Description

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;

Change History (3)

comment:1 by robe, 6 years ago

Milestone: PostGIS 2.3.0PostGIS 2.2.1

comment:2 by robe, 6 years ago

(In [14551]) provide table example for parse_address references #3417

comment:3 by robe, 6 years ago

Resolution: fixed
Status: newclosed

(In [14552]) provide table example for parse_address closes #3417

Note: See TracTickets for help on using tickets.