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

[Axel Rau]

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....@chaos1.de  PGP-Key:29E99DD6  +49 151 2300 9283  computing @  
chaos claudius


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql