e.g. I know you can do
Which is similar to saying tags @> '{music}'.select * from post
where 'music' = any(tags);
where 'music' = any(tags);
select * from post
where 'music' LIKE any(tags);
where 'music' LIKE any(tags);
...implying that ANY is more general in some ways than @>,
e.g. it can would with LIKE as well as =.
But is there any way to do:
select * from post
where any(tags) LIKE 'music%';
where any(tags) LIKE 'music%';
??
This doesn't work because ANY is only allowed on the right.
Thanks!
Ryan