RE: Concat error in PL/pgsql

A few hours ago, I wrote:
>
> Simple add lines as shown:
>
> >     for r in select * from tconcattest loop
>         IF r.str IS NOT NULL THEN
> >             output := output || r.str;
>         END IF;
> >     end loop;
>


This would probably be better:

    for r in select * from tconcattest where str is not null loop
        output := output || r.str;
    end loop;