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 !
