On Fri, Mar 18, 2022 at 3:06 PM Erwin Brandstetter
wrote:
>
> On Fri, 18 Mar 2022 at 22:28, Tom Lane wrote:
>
>> Erwin Brandstetter writes:
>> >
>> https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
>> > The manual says:
>> >> count ( "any" ) → bigint
>>
On Fri, 18 Mar 2022 at 22:28, Tom Lane wrote:
> Erwin Brandstetter writes:
> >
> https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
> > The manual says:
> >> count ( "any" ) → bigint
> >> Computes the number of input rows in which the input value is not
Erwin Brandstetter writes:
> https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
> The manual says:
>> count ( "any" ) → bigint
>> Computes the number of input rows in which the input value is not null.
> But ROW values or composite types that "are null"
https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
The manual says:
count ( "any" ) → bigint
>
> Computes the number of input rows in which the input value is not null.
>
But ROW values or composite types that "are null" are counted, anyway. See: