Thread: question

question

From
Alexander S
Date:
Hi
There is question. Does postgres 7.4  support now such expressions with
array and regex?
select * from my_table where '%Petrov%' ~ any ("surname");
or  select * from my_table where '%Petrov%' = any ("surname");
--where column surname is varchar[] .