Postgres Pro
Downloads
Home   >   mailing lists

Re: Document aggregate functions better w.r.t. ORDER BY - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Document aggregate functions better w.r.t. ORDER BY
Date
Msg-id ZTmjNdH23NWO9A6g@momjian.us
Whole thread Raw
In response to Re: Document aggregate functions better w.r.t. ORDER BY  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Document aggregate functions better w.r.t. ORDER BY
List pgsql-hackers
Tree view 
On Wed, Oct 25, 2023 at 04:14:11PM -0700, David G. Johnston wrote:
> Yeah, we punt on the entire concept in the data type section:
> 
> "Managing these errors and how they propagate through calculations is the
> subject of an entire branch of mathematics and computer science and will not be
> discussed here," ...
> 
> Also, I'm now led to believe that the relevant IEEE 754 floating point addition
> is indeed commutative.  Given that, I am inclined to simply not add the order
> by clause at all to those four functions. (actually, you already got rid of the
> avg()s but the sum()s are still present, so just those two).

Ah, yes, sum() removed.  Updated patch attached.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.
Attachment

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Document aggregate functions better w.r.t. ORDER BY
Next
From: Michael Paquier
Date:
Subject: Re: pg_stat_statements and "IN" conditions