Hey Axel, How about this solution: UPDATE foo SET x = y WHERE ANY(string_to_array(blah, ',')) = id; ?
2010/10/25 Axel Rau <axel....@chaos1.de> > Good morning, > > I have a function argument blah of type text containing something like > 33,44,55,66 > . Can I cast it in some way to use it in an IN clause as integers like > UPDATE foo SET x = y WHERE id IN ( blah ); > or need I revert to dynamic SQL (EXECUTE...) ? > > Thanks, 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 > -- // Dmitriy.
