Re: [GENERAL] Question with combining ANY with ilike

On Dec 12, 2008, at 6:12 AM, Tom Lane wrote: Rusty Conover 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

Re: [GENERAL] Question with combining ANY with ilike

Rusty Conover 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 t

[GENERAL] Question with combining ANY with ilike

Hi PostgreSQL, 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, bu