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?
3 + unknown value = unknown value
its also unknown if 3 is bigger, smaller or equal to an unknown value.
--
Hans de Bruin
http://eratosthenes.xs4all.nl
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
