RE: [BUGS] Concat error in PL/pgsql

[Andrew Snow]

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;