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
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$