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
>
>