Postgres Pro
Downloads
Home   >   mailing lists

Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause - Mailing list pgsql-sql

From Dmitriy Igrishin
Subject Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause
Date
Msg-id AANLkTimh+qbFtPunD8v2iq-X3CRrdzcHZxA6qzz4L8go@mail.gmail.com
Whole thread Raw
In response to Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-sql
Tree view
Ooops, sorry
UPDATE foo SET x = y WHERE id = ANY(string_to_array(blah, ',')::integer[]);

2010/10/29 Dmitriy Igrishin <dmitigr@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.Rau@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.rau@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.


pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause
Next
From: Will Furnass
Date:
Subject: Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable