Re: [GENERAL] pl/pgsql string combining

[Bino Oetomo]

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general