Re: Re: PostgreSQL needs percentage function

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Re: PostgreSQL needs percentage function
Date: 2017-12-18 19:35:54
Message-ID: 20171218193554.3wsxivbkyatfnqpd@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2017-12-18 09:21:49 -0700, David G. Johnston wrote:
> Frankly, the name "percent" is a poor choice:
[...]
> And why is percent >1 as opposed to (generally) between 0 and 1?

That's what "per cent" means: "of hundred". The whole is 100. If the
whole is 1, it's not a percentage (and yes, percent_rank() is misnamed).

hp

--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2017-12-18 19:39:41 Re: reclaiming space from heavily used tables?
Previous Message Peter J. Holzer 2017-12-18 19:30:23 Re: Re: PostgreSQL needs percentage function