Search Postgresql Archives
regexp searching in arrays not working?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: regexp searching in arrays not working?
- From: "Rhys Stewart" <rhys.stewart@xxxxxxxxx>
- Date: Tue, 19 Jun 2007 18:15:43 -0500
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=op61Sf9cSmyrCaQZthGaieGeeLdlG8jRvaPTpoIbq7lg+TcNaCbNoV0xCUCpJMCj6SOc/A1d6R24fRpzj98X+TGgthcmRlAVMsBu7CloNfuXld6YbVY6czT/hzBqQP7B0nyz8bzEIUqpcz6R+gn43eS1iCWS7G1f5C6Q7WyL0Qk=
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]