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[] .
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных