Ooops, sorry UPDATE foo SET x = y WHERE id = ANY(string_to_array(blah, ',')::integer[]);
2010/10/29 Dmitriy Igrishin <[email protected]> > Hey Axel, > > How about this solution: > UPDATE foo SET x = y WHERE ANY(string_to_array(blah, ',')) = id; > ? > > 2010/10/25 Axel Rau <[email protected]> > > 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 >> --- >> [email protected] PGP-Key:29E99DD6 +49 151 2300 9283 computing @ >> chaos claudius >> >> >> -- >> Sent via pgsql-sql mailing list ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-sql >> > > > > -- > // Dmitriy. > > > -- // Dmitriy.
