"Gerwin Philippo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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?
COALESCE is your friend... ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
