Re: Array with Subselect / ANY - cast? - Mailing list pgsql-general

On Tue, 21 Aug 2007 20:15:59 +0200
"Pavel Stehule" <pavel.stehule@gmail.com> wrote:

> SELECT * FROM ... WHERE 1000 IN (SELECT pb_ids FROM pb WHERE id=123)
>
> or
>
> SELECT * FROM ... WHERE 1000 = ANY(ARRAY(SELECT pb_ids FROM pb
> WHERE id=123))

Thanks - another way:

SELECT * FROM ... WHERE 1000 = ANY((SELECT pb_ids FROM pb
WHERE id=123)::integer[])

Josh