Re: bug or feature, || -operator and NULLs - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: bug or feature, || -operator and NULLs
Date
Msg-id FA095C015271B64E99B197937712FD020E4B0DE4@freedom.grz.icomedias.com
Whole thread Raw
In response to Re: bug or feature, || -operator and NULLs  (Lukas Kahwe Smith <smith@pooteeweet.org>)
Responses Re: bug or feature, || -operator and NULLs  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-hackers
>
>If you want this behaviour you will have to explicitly handle it with
COALESCE().
>
>regards,
>Lukas

True. But there's a point where oracle is really better here, they named
"coalesce" "nvl" => a lot easier to type ;-)


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Bug?
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: bug or feature, || -operator and NULLs