Re: NVL vs COALESCE - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: NVL vs COALESCE
Date
Msg-id 4385B58D.3090804@familyhealth.com.au
Whole thread Raw
In response to Re: NVL vs COALESCE  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: NVL vs COALESCE
Next
From: Peter Eisentraut
Date:
Subject: Re: PL/php in pg_pltemplate