append columns that are null - Mailing list pgsql-sql

From Gerwin Philippo
Subject append columns that are null
Date
Msg-id 40ec1043$0$559$e4fe514c@news.xs4all.nl
Whole thread Raw
List pgsql-sql
I have function that appends 2 columns, like
"new.field1 = new.field2||new.field3",
but when field 3 is null, then the entire outcome is null, while I 
expected just field2, since when I append nothing to field2, I get 
field2, right?
Is this standard behaviour, and if so, is there another append function 
that I can use that doesn't behave like this?


pgsql-sql by date:

Previous
From: "Sarah Tanembaum"
Date:
Subject: Secure DB Systems - How to
Next
From: Hans de Bruin
Date:
Subject: Re: append columns that are null