Re: Proposal: revert behavior of IS NULL on row types

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Proposal: revert behavior of IS NULL on row types
Дата
Msg-id 87invxqkfz.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: Proposal: revert behavior of IS NULL on row types  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
>>>>> "David" == David G Johnston <david.g.johnston@gmail.com> writes:
>> 1. x IS NULL  is true if and only if x has the null value (isnull set).
David> ​I don't have a problem conforming to "ROW(NULL, NULL) IS NULL"David> being true...​if you somehow get a hold of
somethingin thatDavid> form, which your others points address. 

This seems harmless, but I think it's not worth the pain.

I'm informed that for example on Oracle:
 select case when foo_type(null, null) is null             then 'true' else 'false'         end from dual;

returns 'false'.

--
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Proposal: revert behavior of IS NULL on row types
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Proposal: revert behavior of IS NULL on row types