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:[EMAIL PROTECTED] > 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster