pgsql: Fix behavior of float aggregates for single Inf or NaN inputs.

2020-06-13 Thread Tom Lane
Fix behavior of float aggregates for single Inf or NaN inputs. When there is just one non-null input value, and it is infinity or NaN, aggregates such as stddev_pop and covar_pop should produce a NaN result, because the calculation is not well-defined. They used to do so, but since we adopted You

pgsql: Fix behavior of float aggregates for single Inf or NaN inputs.

2020-06-13 Thread Tom Lane
Fix behavior of float aggregates for single Inf or NaN inputs. When there is just one non-null input value, and it is infinity or NaN, aggregates such as stddev_pop and covar_pop should produce a NaN result, because the calculation is not well-defined. They used to do so, but since we adopted You

pgsql: Fix behavior of float aggregates for single Inf or NaN inputs.

2020-06-13 Thread Tom Lane
Fix behavior of float aggregates for single Inf or NaN inputs. When there is just one non-null input value, and it is infinity or NaN, aggregates such as stddev_pop and covar_pop should produce a NaN result, because the calculation is not well-defined. They used to do so, but since we adopted You