Re: is this possible in plpgsql ?

On Thursday 19 Jun 2003 1:38 am, Marcin Winkler wrote:
> I have 1 function in pg 7.3.2.
>
> txt string have 1,2,3,.. and i would like to be similar like if 3 in
> (1,2,3..) then, but IF 3 in (''''||txt||'''') THEN doesn't work.
> There is possible to this or not ?

> txt := '''';
> for i in 1 .. 10 loop
> txt := txt||i||'','';
> END loop;
> txt := txt||''0'';
> IF 3 in (''''||txt||'''') THEN
> raise notice ''yep'';

Try something like:

query:=''SELECT 3 in ('' || txt || '')''
EXECUTE query;

Then check the result for true/false

--
Richard Huxton