Is it possible to specify an ESCAPE for a wildcard search using LIKE ANY (...)

Thomas Kellerer <spam_eater@xxxxxxx> · Tue, 17 Jan 2017 09:25:38 +0100

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general