[PostGIS] #2459: Speed up pagc_normalize_address

[PostGIS]

#2459: Speed up pagc_normalize_address
----------------------------------+-----------------------------
  Reporter:  robe                 |      Owner:  robe
      Type:  enhancement          |     Status:  closed
  Priority:  medium               |  Milestone:  PostGIS Fund Me
 Component:  pagc_address_parser  |    Version:  master
Resolution:  fixed                |   Keywords:
----------------------------------+-----------------------------
Changes (by Darafei Praliaskouski <me@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"bd6ef65e8d418d17064225b182347478ebe84b11/git" bd6ef65/git]:
 {{{#!CommitTicketReference repository="git"
 revision="bd6ef65e8d418d17064225b182347478ebe84b11"
 #2459 Improve tiger geocoder wrapper normalization

 Speed up pagc_normalize_address with a single standardize_address() call
 while preserving ZIP+4, country, and ZIP-only fallbacks. Convert several
 expression-only tiger wrappers to SQL where install order allows, preserve
 extension schema qualifications, and refresh the related docs and
 regression coverage.

 Closes #2459
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2459#comment:6>
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.