Re: NVL vs COALESCE - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: NVL vs COALESCE
Date
Msg-id 7DF53811-C757-4F1C-9FFE-44D227AF3CD2@myrealbox.com
Whole thread Raw
In response to NVL vs COALESCE  (Marcus Engene <mengpg@engene.se>)
Responses Re: NVL vs COALESCE  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: NVL vs COALESCE  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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





pgsql-hackers by date:

Previous
From: Marcus Engene
Date:
Subject: NVL vs COALESCE
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: NVL vs COALESCE