I recently stumbled over the need to use a wildcard escape character for a condition that makes use of LIKE ANY,
somethinglike:
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
areuser_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