Re: [SQL] append columns that are null

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 fie

Re: [SQL] append columns that are null

"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,

Re: [SQL] append columns that are null

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 funct

Re: [SQL] append columns that are null

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

[SQL] append columns that are null

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 f

Re: [SQL] append columns that are null

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, s