regexp searching in arrays not working?

Поиск
Список
Период
Сортировка
От Rhys Stewart
Тема regexp searching in arrays not working?
Дата
Msg-id 189966030706191615sc6772c7i7c549df8e8b7cfdb@mail.gmail.com
обсуждение исходный текст
Ответы Re: regexp searching in arrays not working?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Henrik Zagerholm
Дата:
Сообщение: Iterate over an array in stored procedure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: regexp searching in arrays not working?