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 bet
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;
- Andrew
Hans Peter Wuermli <[EMAIL PROTECTED]> writes:
> Within a plpgsql function, concatenating TEXT strings from tables that
> allow NULL values return nil results.
That's not a bug: NULL concatenated with anything produces NULL,
per SQL92 specification.
If you want a NULL to act like an empty string
