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

From Jim C. Nasby
Subject Re: bug or feature, || -operator and NULLs
Date
Msg-id 20061018183822.GF85041@nasby.net
Whole thread Raw
In response to Re: bug or feature, || -operator and NULLs  ("Mario Weilguni" <mario.weilguni@icomedias.com>)
List pgsql-hackers
Yes, well, we english speakers get to deal with the monstrosity that is
'www'. :)

In any case, I believe coalesce is in the standard, and even if it's
not, Oracle is the only database I know of that doesn't use it.

If you're that unhappy with coalesce and ||, you can always create
functions that will do what you want.

On Wed, Oct 18, 2006 at 04:15:00PM +0200, Mario Weilguni wrote:
> Yes it's hard for me, maybe because I am no native english speaker. 
> 
> -----Urspr?ngliche Nachricht-----
> Von: Andrew Dunstan [mailto:andrew@dunslane.net] 
> Gesendet: Mittwoch, 18. Oktober 2006 16:11
> An: Lukas Kahwe Smith
> Cc: Mario Weilguni; pgsql-hackers@postgresql.org
> Betreff: Re: [HACKERS] bug or feature, || -operator and NULLs
> 
> Lukas Kahwe Smith wrote:
> > Mario Weilguni wrote:
> >> Nice, but I still prefer nvl. Coalesce is hard to pronounce, and even 
> >> harder to type.
> >
> > amen .. coalesce was invented by a sadistic twit (something which 
> > people have also called me .. so it goes).
> 
> Perhaps people are trying to pronounce it wrongly. According to m-w, the right ways is:
> 
>    Pronunciation: "kO-&-'les
> 
> 
> or more informally "koh a less".
> 
> Is that really so hard?
> 
> cheers
> 
> andrew
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 

-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: bug or feature, || -operator and NULLs
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Bug?