Re: Documentation, window functions - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Documentation, window functions
Date
Msg-id 4C9F51DD0200002500035DF5@gw.wicourts.gov
Whole thread Raw
In response to Documentation, window functions  (Dennis Björklund <db@zigo.dhs.org>)
List pgsql-hackers
Robert Haas  wrote:
> Hmm... it is true that average will produce the same results on any
> ordering of the same set of input values, though.
Not exactly.  For floating point approximations you get a more
accurate sum (and therefore a more accurate average) if you add the
values in ascending order of absolute value.  Depending on the data,
it can make quite a difference.
-Kevin



pgsql-hackers by date:

Previous
From: Marios Vodas
Date:
Subject: Re: C function to return tuple
Next
From: Magnus Hagander
Date:
Subject: Re: Congratulations on leaving CVS