Creating a function
Hi,
I am trying to create a function to bin based on user value and I am
stuck. I followed the
postgres 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
point
Glenn
CREATE FUNCTION "IncentiveBin"(in Gwac double precision,
in MtgRaate double precision,
in BinSize double precision)
RETURNS double precision
LANGUAGE 'sql'
VOLATILE PARALLEL SAFE
AS
$function$
BEGIN
ceiling((Gwac - MtgRate)/BinSize) * BinSize;
END
$function$
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);
Pavel
Dne 28.11.2018 10:35:09, "Glenn Schultz" <glenn@bondlab.io> napsal:
Show quoted text
Hi,
I am trying to create a function to bin based on user value and I am
stuck. I followed the
postgres 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 pointGlenn
CREATE FUNCTION "IncentiveBin"(in Gwac double precision,
in MtgRaate double precision,
in BinSize double precision)
RETURNS double precision
LANGUAGE 'sql'
VOLATILE PARALLEL SAFE
AS
$function$
BEGIN
ceiling((Gwac - MtgRate)/BinSize) * BinSize;
END
$function$