Re: COALESCE and NULLIF semantics - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: COALESCE and NULLIF semantics
Date
Msg-id 1252707224.9975.118.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: COALESCE and NULLIF semantics  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: COPY enhancements
Next
From: Emmanuel Cecchet
Date:
Subject: Re: COPY enhancements