Re: Subselects returning array and ANY... - Mailing list pgsql-sql

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