Home > mailing lists

Re: Why does this array query fail? - Mailing list pgsql-general

From	bricklen
Subject	Re: Why does this array query fail?
Date	September 17, 2013 04:07:10
Msg-id	CAGrpgQ_fT9pV_0Xx72p=3SqjyqydA3nu+ZLN3ysC0GXj3yk0Hg@mail.gmail.com Whole thread Raw
In response to	Why does this array query fail? (Ken Tanzer <ken.tanzer@gmail.com>)
List	pgsql-general

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

From: karinos57
Date: 17 September 2013, 03:57:27
Subject: using Replace funcion in postgresql

From: John R Pierce
Date: 17 September 2013, 04:09:33
Subject: Re: using Replace funcion in postgresql