Re: NVL vs COALESCE

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: NVL vs COALESCE
Дата
Msg-id 4385B58D.3090804@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: NVL vs COALESCE  (Michael Glaesemann <grzm@myrealbox.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: NVL vs COALESCE
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: PL/php in pg_pltemplate