Hi all, have a column which is of type text[]. the following works:
select * from table where 'Transformer' = ANY (thiscol) this also works select * from table where 'Transformer' ~ ANY (thiscol) however if i have a partial string like so select * from table where 'Trans' ~ ANY (thiscol) it returns nothing. Is regex searching not functioning (as i expect it to?) i searched the docs and didnt see anything about it. Regards Rhys