Re: Creating a function
От | Pavel Křehula |
---|---|
Тема | Re: Creating a function |
Дата | |
Msg-id | emd03fad66-0848-4689-a611-43ac8118d8a7@pavel6 обсуждение исходный текст |
Ответ на | Creating a function (Glenn Schultz <glenn@bondlab.io>) |
Список | pgsql-general |
Hi,
something like this?
create or replace FUNCTION "IncentiveBin"(in Gwac double precision,
in MtgRaate double precision,
in BinSize double precision)
RETURNS double precision
LANGUAGE sql
VOLATILE PARALLEL SAFE
as 'select ceiling(($1 - $2)/$3) * $3;';
select "IncentiveBin"(1000.0,9,212);
in MtgRaate double precision,
in BinSize double precision)
RETURNS double precision
LANGUAGE sql
VOLATILE PARALLEL SAFE
as 'select ceiling(($1 - $2)/$3) * $3;';
select "IncentiveBin"(1000.0,9,212);
Pavel
Dne 28.11.2018 10:35:09, "Glenn Schultz" <glenn@bondlab.io> napsal:
Hi,I am trying to create a function to bin based on user value and I am stuck. I followed thepostgres create function tutoriall but I am missing something. Any help would be appreciated as I think I am just going further off course at this pointGlennCREATE FUNCTION "IncentiveBin"(in Gwac double precision,in MtgRaate double precision,in BinSize double precision)RETURNS double precisionLANGUAGE 'sql'VOLATILE PARALLEL SAFEAS$function$BEGINceiling((Gwac - MtgRate)/BinSize) * BinSize;END$function$
В списке pgsql-general по дате отправления: