I recently stumbled over the need to use a wildcard escape character for a condition that makes use of LIKE ANY, something like:
select * from some_table where name like any (array['foo_bar%', 'bar_foo%']) escape '/'; so that the underscore wouldn't be treated as a wildard (I can't really change the values _inside_ the array as they are user_provided). The above throws a syntax error. So my question is: Is there any way to specify an alternate wildcard escape when using LIKE ANY (..)? Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
