Re: [GENERAL] Why does this array query fail?

[bricklen]

On Mon, Sep 16, 2013 at 5:32 PM, Ken Tanzer <ken.tan...@gmail.com> wrote:

> SELECT 'found' WHERE 'test' = ANY( (SELECT ARRAY['test','pass','fail']) );
>


It works if you drop the inner SELECT.

SELECT 'found' WHERE 'test' = ANY( ARRAY['test','pass','fail'] );