On Mon, Sep 16, 2013 at 6:36 PM, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:
> Thanks for the explanation. I think I at least understand what it's doing
> now. I'm either surprised or confused though, as I was under the
> impression that you could substitute a subquery for a value pretty much
> anywhere, but I guess that's not the case?
>
> Cheers,
> Ken
>
>
Your subquery can also be explicitly casted to make it work. Note the
"::TEXT[]"
SELECT 'found' WHERE 'test' = ANY( (SELECT
ARRAY['test','pass','fail'])::TEXT[] );