Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: NVL vs COALESCE
- From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
- Cc: Marcus Engene <mengpg(at)engene(dot)se>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: NVL vs COALESCE
- Date: Thu, 24 Nov 2005 20:43:57 +0800
- Message-id: <4385B58D(dot)3090804(at)familyhealth(dot)com(dot)au>
If we're going to do that we should add IFNULL() from MySQL as well... Chris Michael Glaesemann wrote:
On Nov 24, 2005, at 21:21 , Marcus Engene wrote:When we're having an alias discussion, I'd really like to see NVL in postgres. Not because of porting from oracle as much as just spelling that without the reference manual is completely impossible.NVL: what a very unfortunate spelling. (NULL VaLue? NULL Valued Logic? Named Very Loosely? Someone help me here :) ) AFAICT, COALESCE is SQL standard, while NVL isn't. I think an index entry might be a good idea.Michael Glaesemann grzm myrealbox com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
- References:
- NVL vs COALESCE
- From: Marcus Engene
- Re: NVL vs COALESCE
- From: Michael Glaesemann
- NVL vs COALESCE
- Prev by Date: Re: NVL vs COALESCE
- Next by Date: Re: PL/php in pg_pltemplate
- Previous by thread: Re: NVL vs COALESCE
- Next by thread: Re: NVL vs COALESCE
- Indexes: