Re: Re: PostgreSQL needs percentage function

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Re: PostgreSQL needs percentage function
Дата
Msg-id 20171218193554.3wsxivbkyatfnqpd@hjp.at
обсуждение исходный текст
Ответ на Re: Re: PostgreSQL needs percentage function  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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/>

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Re: PostgreSQL needs percentage function
Следующее
От: Jeremy Finzel
Дата:
Сообщение: Re: reclaiming space from heavily used tables?