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[] .
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.