[Geocoding] [OpenStreetMap] #4389: decode_url_part is only compatible with postgresql >= 9.0

[OpenStreetMap]

#4389: decode_url_part is only compatible with postgresql >= 9.0
-----------------------+----------------------------------------------------
 Reporter:  lokkju     |       Owner:  geocoding@…                
     Type:  defect     |      Status:  new                        
 Priority:  major      |   Milestone:                             
Component:  nominatim  |     Version:  2.0                        
 Keywords:             |  
-----------------------+----------------------------------------------------
 The decode_url_part function in functions.sql is only compatible with
 version of postgresql >= 9.0 due to the use of the 'string_agg' function.

 An alternative implementation of decode_url_part function that is
 compatible with postgresql 8.4 is provided on the same stackoverflow page
 that provided the 9.0+ implementation.  I would suggest either just using
 the 8.4 compatible version, or else conditionally using one or the other
 based on the postgresql version.

-- 
Ticket URL: <https://trac.openstreetmap.org/ticket/4389>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world