Array, ANY and Regular Expressions - Mailing list pgsql-general

I have a table with an array column (tags text[]) which I want to
select from via ANY and RegExes.

 SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order by
 ident;

delivers 7 rows

 SELECT tags from zettelkasten where 'SoziALPSychologie---FOOBARBAZ' ~* any(tags)
 order by ident;

also delivers 7 rows,

however:

 SELECT tags from zettelkasten where 'sozial' ~* any(tags) order by ident;

delivers 0 rows.


So how do I select all entries from "zettelkasten" tagged with
e.g. '*psycholog*'?




PS: Keep me CC:'ed, I am not subscribed to this list

mit freundlichen Grüßen
Stefan Schumacher
--
https://deepsec.net/schedule/

Desing and Implementation of Security Awareness Campaigns at
DeepSec Security Conference Vienna/Austria 2008-11-11