|
Hi: create
table foo (lst text[]); insert
into foo (lst) values (array[‘jack’,’fred’,’jen’,’sue’]); I
want to find all records where any element of lst like ‘j%’. This
does not work... select * from foo where ‘j%’ like any(lst); Intuitively,
you’d think.... select * from foo where any(lst) like ‘j%’;
...
but that’s a syntax error. Can
this be done? Thanks
in Advance ! |
