Re: count() counts ROW values that are NULL

2022-03-18 Thread David G. Johnston
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 >>

Re: count() counts ROW values that are NULL

2022-03-18 Thread Erwin Brandstetter
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

Re: count() counts ROW values that are NULL

2022-03-18 Thread Tom Lane
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"

count() counts ROW values that are NULL

2022-03-18 Thread Erwin Brandstetter
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: