I'd be out of work very soon :(
nobody wrote:
You are welcome. Only if all problems were that simple ;-)... "Gerwin Philippo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
THX! didn't know that one yet :)
nobody wrote:
"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 8: explain analyze is your friend
