Re: pl/pgsql string combining

[Bino Oetomo <bino@xxxxxxxxxxxxxxxxxxxx>]

Dear Mr. Stehule

Thankyou for your super prompt (came to my mailbox less then 2 minutes 
since my post) enlightment.

I'll try it

Sincerely
-bino-

Pavel Stehule wrote:
> Hello
>
> NULL and any is NULL. So you have to use "coalesce" function.
>
> like
>
> NEW.prefix = ctrcode || coalesce(NEW.code, '');
>
> Regards
> Pavel Stehule
>
>   


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general