Regexp matching + typecasts - Mailing list pgsql-general

Numbers in "{}" are itemid's:

# select itemid,status from items;
 itemid | status
 24324 |      1
 34842 |      0
 36078 |      1

I need to find all active (status=0) items not belonging to any active trigger. The best I could come up with is this:

select count(itemid) from items where status='0' and itemid not in (select cast(regexp_matches(expression,'{([^}]+)}','g') as integer) from triggers where status='0');

However, the cast doesn't work:
ERROR:  cannot cast type text[] to integer

Or maybe I'm not using it right.

Anyone could provide an insight?

This is on postgresql 9.2.

--
Ilya.