On 18/12/2017 14:23, 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
CREATE OR REPLACE FUNCTION percent(xall float,xper float) RETURNS float
LANGUAGE sql IMMUTABLE STRICT
AS $$ select xall * xper / 100.0 $$;
Seems like a nice addition to the math functions list:
https://www.postgresql.org/docs/9.5/static/functions-math.html
This is veryhelpull function, many uses percentage calculation in thier work and it will simplify the process. Percentage calculation is considered a basic math operation and I think postgresql
should support it as a build-in function.
Seems like easy to implment isn't it?
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
