Reporter: lokkju
[Submitted to the original trac issue database at 9.58pm, Wednesday, 2nd May 2012]

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.