Re: NVL vs COALESCE

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