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[] .
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
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[] .
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?