Thread: Re: append columns that are null
THX! didn't know that one yet :) nobody wrote: > "Gerwin Philippo" <gerwin@vernet.nl> wrote in message > news:40ec1043$0$559$e4fe514c@news.xs4all.nl... > >>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... > >
You are welcome. Only if all problems were that simple ;-)... "Gerwin Philippo" <gerwin@vernet.nl> wrote in message news:40ecf718$0$36169$e4fe514c@news.xs4all.nl... > THX! didn't know that one yet :) > > nobody wrote: > > "Gerwin Philippo" <gerwin@vernet.nl> wrote in message > > news:40ec1043$0$559$e4fe514c@news.xs4all.nl... > > > >>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... > > > >
I'd be out of work very soon :( nobody wrote: > You are welcome. Only if all problems were that simple ;-)... > "Gerwin Philippo" <gerwin@vernet.nl> wrote in message > news:40ecf718$0$36169$e4fe514c@news.xs4all.nl... > >>THX! didn't know that one yet :) >> >>nobody wrote: >> >>>"Gerwin Philippo" <gerwin@vernet.nl> wrote in message >>>news:40ec1043$0$559$e4fe514c@news.xs4all.nl... >>> >>> >>>>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... >>> >>> > > >