regexp searching in arrays not working?

From: "Rhys Stewart" <rhys(dot)stewart(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: regexp searching in arrays not working?
Date: 2007-06-19 23:15:43
Message-ID: 189966030706191615sc6772c7i7c549df8e8b7cfdb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-19 23:36:02 Re: regexp searching in arrays not working?
Previous Message Joshua D. Drake 2007-06-19 23:11:28 Re: Excell