Dawid,
> SELECT * FROM foo WHERE t = ANY (SELECT '{x4,5,zzz}'::text[]);
> ERROR: operator does not exist: text = text[]
> HINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
Drop the second SELECT, I think.
postgres=# select 'x' = ANY ( '{x,y,z}'::TEXT[] );?column?
----------t
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco