Postgresql 8.4 Like Concat

Question

my query in postgresql 9.3 is:

SELECT *
    FROM route
    WHERE 'my/uri/address' LIKE CONCAT(c_uri, '%')

But in postgresql 8.4 this code not working.

How can i resolve, please?

Thanks in advance!

Answer 1

In PostgreSQL version 8.4 to String concatenation use || operation.

Example:'Post' || 'greSQL'

Result is: PostgreSQL