"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?
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
