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

From hubert depesz lubaczewski
Subject Re: PostgreSQL needs percentage function
Date
Msg-id 20171218154449.GA19797@depesz.com
Whole thread Raw
List pgsql-general
On Mon, Dec 18, 2017 at 02:23:38PM +0200, Nick Dro wrote:
>    Hi,
>    Why PostgreSQL doesn't have build-in function to calculate percentage?
>    somthing like percent(number,%
>    for example:
>    select percent(100,1) will calculate 1% of 100 = 1
>    select percent(25,20) will calculate 20% of 25 = 5

What is the problem with using normal multiplication for this?

depesz


pgsql-general by date:

Previous
From: David Steele
Date:
Subject: Re: PgBackRest question?
Next
From: Geoff Winkless
Date:
Subject: Re: Re: PostgreSQL needs percentage function