Re: Subselects returning array and ANY...

[Josh Berkus <josh(at)agliodbs(dot)com>]

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