On Tue, Jan 17, 2017 at 03:27:57PM +0100, Thomas Kellerer wrote:
>> Do you need to have the _ NOT be recognized as a wildcard ?
>
> Yes, the underscore should NOT be a wildcard in this case.
Understood.
So, as Tom hinted at, your best bet might be to write a
function escape_underscore_in_1dim_text_array(IN TEXT[], OUT TEXT[])
...
which takes an array and puts '\' in front of every '_' of
each member such that you can write
... like any (escape_underscore_in_1dim_text_array(your_array)) ...
Would that solve the problem ?
(this assume *no* underscore is to be a wildcard in user
provided input, not just some)
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
