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