Re: Re: PostgreSQL needs percentage function - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Re: PostgreSQL needs percentage function
Date
Msg-id 20171218193554.3wsxivbkyatfnqpd@hjp.at
Whole thread Raw
In response to Re: Re: PostgreSQL needs percentage function  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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@hjp.at         | management tools.
__/   | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>

Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Re: PostgreSQL needs percentage function
Next
From: Jeremy Finzel
Date:
Subject: Re: reclaiming space from heavily used tables?