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

2007/8/21, Josh Trutwin <josh@trutwins.homeip.net>:
> 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[])
>

it works? no.

pavel=# select 1 from (values(10)) a(i)  where i = any((select * from
foo)::int[]);
ERROR:  cannot cast type integer to integer[]
LINE 1: ...values(10)) a(i)  where i = any((select * from foo)::int[]);
                                                                ^
pavel=#