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