Re: Creating a function

[Pavel Křehula]

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" <gl...@bondlab.io> napsal:

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$