Re: question about count(b) where b is a custom type - Mailing list pgsql-hackers

From Richard Huxton
Subject Re: question about count(b) where b is a custom type
Date
Msg-id 437B304A.1030806@archonet.com
Whole thread Raw
In response to Re: question about count(b) where b is a custom type  ("Pollard, Mike" <mpollard@cincom.com>)
List pgsql-hackers
Pollard, Mike wrote:
>>Firstly, if you just want a count, what's wrong with count(1) or
>>count(*).
>>
> 
> 
> Because unless the column does not allow nulls, they will not return the
> same value.

Ah, but in the example given the column was being matched against a 
value, so nulls were already excluded.

--   Richard Huxton  Archonet Ltd


pgsql-hackers by date:

Previous
From: "Pollard, Mike"
Date:
Subject: Re: question about count(b) where b is a custom type
Next
From: "Pollard, Mike"
Date:
Subject: Re: question about count(b) where b is a custom type