Re: Why does this array query fail?

[bricklen <bricklen@xxxxxxxxx>]

On Mon, Sep 16, 2013 at 5:32 PM, Ken Tanzer <ken.tanzer@xxxxxxxxx> 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'] );