Ooops, sorry UPDATE foo SET x = y WHERE id = ANY(string_to_array(blah, ',')::integer[]);
2010/10/29 Dmitriy Igrishin <dmit...@gmail.com> > 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. > > > -- // Dmitriy.
