Thomas Kellerer <spam_eater@xxxxxxx> writes:
> So my question is: Is there any way to specify an alternate wildcard escape when using LIKE ANY (..)?
No, not with ESCAPE. [ manfully resists temptation to run down SQL
committee's ability to design composable syntax ... oops ]
You could do what PG does under the hood, which is to run the pattern
through like_escape():
select *
from some_table
where name like any (array[like_escape('foo_bar%', '/'),
like_escape('bar_foo%', '/')]);
If that seems too verbose, maybe build a function to apply like_escape
to each member of an array.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
