Re: COALESCE and NULLIF semantics

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: COALESCE and NULLIF semantics
Дата
Msg-id 1252707224.9975.118.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответ на Re: COALESCE and NULLIF semantics  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, 2009-09-11 at 17:35 -0400, Tom Lane wrote:
> Eh?  It's a null value of a composite type.  The above is a type
> violation.

The spec calls it "the null value" which is included in all domains
(Framework 4.4.2). However, in the same section, it mentions "the data
type of the null value", so apparently each null does have a specific
type.

It seems to me like the spec would have something to say about
ROW(NULL,NULL) versus NULL. Do other systems make a distinction?

Regards,Jeff Davis



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: COPY enhancements
Следующее
От: Emmanuel Cecchet
Дата:
Сообщение: Re: COPY enhancements