Postgres Pro
Downloads
Home   >   mailing lists

Creating a function - Mailing list pgsql-general

From Glenn Schultz
Subject Creating a function
Date
Msg-id CAE-4=KGDXZSLsU+TZMs1qBjbA8ChtB97+v73LEHtfyWU2V+pbQ@mail.gmail.com
Whole thread Raw
Responses Re: Creating a function
List pgsql-general
Tree view
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: Sergei Agalakov
Date:
Subject: Re: pg_stat_statements: can we extend the object names to thequalified names?
Next
From: Pavel Křehula
Date:
Subject: Re: Creating a function