On Mon, Jan 28, 2008 at 04:38:01PM -0500, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
> > I've just noticed that the handling of COUNT(record) and (record IS
> > NULL) aren't consistent with my understanding of them. If I run the
> > following query:
>
> > SELECT
> > NULL
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Sam Mason <[EMAIL PROTECTED]> writes:
>> I've just noticed that the handling of COUNT(record) and (record IS
>> NULL) aren't consistent with my understanding of them. If I run the
>> following query:
>
>> SELECT
>> NULL IS NULL, COUNT( NULL
Sam Mason <[EMAIL PROTECTED]> writes:
> I've just noticed that the handling of COUNT(record) and (record IS
> NULL) aren't consistent with my understanding of them. If I run the
> following query:
> SELECT
> NULL IS NULL, COUNT( NULL ),
> (NULL,NULL) IS NULL, COUNT((NULL,NUL
Hi,
I've just noticed that the handling of COUNT(record) and (record IS
NULL) aren't consistent with my understanding of them. If I run the
following query:
SELECT
NULL IS NULL, COUNT( NULL ),
(NULL,NULL) IS NULL, COUNT((NULL,NULL));
The IS NULL checks both return TRUE as
