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)