Postgres Pro
Downloads
Home   >   mailing lists

regexp searching in arrays not working? - Mailing list pgsql-general

From Rhys Stewart
Subject regexp searching in arrays not working?
Date
Msg-id 189966030706191615sc6772c7i7c549df8e8b7cfdb@mail.gmail.com
Whole thread Raw
Responses Re: regexp searching in arrays not working?
List pgsql-general
Tree view
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 by date:

Previous
From: Henrik Zagerholm
Date:
Subject: Iterate over an array in stored procedure
Next
From: Tom Lane
Date:
Subject: Re: regexp searching in arrays not working?