Rusty Conover <rcono...@infogears.com> writes:
> I'd like to specify a pattern then apply that pattern to match each
> element of an array:
> rconover=# select 'foobar%' ~~ ANY (ARRAY['bar', 'cat', 'foobar:asdf']);
> ?column?
> ----------
> f
> (1 row)
> I'd like the the pattern would be evaluated against all of the array
> elements, but the order of parameters for the ~~ operator when
> combined with the ANY command is backwards to what I need.
Create a reverse-LIKE operator and underlying one-line SQL function.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
