Re: Creating a function - Mailing list pgsql-general

From Pavel Křehula
Subject Re: Creating a function
Date
Msg-id emd03fad66-0848-4689-a611-43ac8118d8a7@pavel6
Whole thread Raw
In response to Creating a function  (Glenn Schultz <glenn@bondlab.io>)
List 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);

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

pgsql-general by date:

Previous
From: Glenn Schultz
Date:
Subject: Creating a function
Next
From: Durgamahesh Manne
Date:
Subject: Regarding Tds_fdw