Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post]

Thanks Richard and Sergey,

your solution works perfect, even if blah contains only one member.

Am 25.10.2010 um 18:17 schrieb Richard Broersma:
>
> Here is what I think should work:
>
> UPDATE foo
> Set x = y
> WHERE id = ANY( CAST( string_to_array( '1,2,3,4', ',' ) AS
> INTEGER[] ));

Axel
---
axel.rau@chaos1.de  PGP-Key:29E99DD6  +49 151 2300 9283  computing @
chaos claudius