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 !