Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle
Дата
Msg-id 42BC0D8C.5070900@dunslane.net
обсуждение исходный текст
Ответ на Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 

Tom Lane wrote:

>[ moving to -hackers for a wider audience ]
>
>Today's issue: should the GREATEST/LEAST functions be strict (return
>null if any input is null) or not (return null only if all inputs are
>null, else return the largest/smallest of the non-null inputs)?
>
>  
>

My initial reaction was to say "not strict", and since that's apparently 
what Oracle does that reinforces it for me.

cheers

andrew

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] O_DIRECT for WAL writes
Следующее
От: Mike Rylander
Дата:
Сообщение: Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)