openGauss-server/src/test/regress/input/udf_crem.source-代码预览-openGauss-server:基于关系型数据库技术的企业级数据库管理系统项目 - AtomGit

15670430创建于 2020年12月28日历史提交
DROP FUNCTION IF EXISTS PUBLIC.trunc(int);
CREATE FUNCTION PUBLIC.trunc(int) RETURNS int
    AS 'select $1'
LANGUAGE SQL strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.trunc(int, int);
CREATE OR REPLACE FUNCTION PUBLIC.trunc(int, int)
RETURNS int
AS '@libdir@/regress@DLSUFFIX@','truncInt'
LANGUAGE c IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.trunc(float4, int);
CREATE OR REPLACE FUNCTION PUBLIC.trunc(float4, int)
RETURNS float8
AS '@libdir@/regress@DLSUFFIX@','truncFloat'
LANGUAGE c IMMUTABLE;

DROP FUNCTION IF EXISTS public.trunc(numeric, int);
CREATE OR REPLACE FUNCTION public.trunc(numeric, int default 0) RETURNS numeric
	AS 'SELECT CASE WHEN $2<6 THEN pg_catalog.trunc($1, $2) ELSE pg_catalog.round(pg_catalog.trunc($1, $2), 5) END'
LANGUAGE SQL strict IMMUTABLE;


DROP FUNCTION IF EXISTS PUBLIC.TransDate(varchar(50), int, varchar(50));
CREATE OR REPLACE FUNCTION PUBLIC.TransDate(varchar(50), int, varchar(50))
RETURNS varchar(50)
AS '@libdir@/regress@DLSUFFIX@','TransDate'
LANGUAGE c IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.TransTimestamp(varchar(50), int, varchar(50));
CREATE OR REPLACE FUNCTION PUBLIC.TransTimestamp(varchar(50), int, varchar(50))
RETURNS varchar(50)
AS '@libdir@/regress@DLSUFFIX@','TransTimestamp'
LANGUAGE c IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.sign(float4);
CREATE OR REPLACE FUNCTION PUBLIC.sign(float4)
RETURNS int
AS '@libdir@/regress@DLSUFFIX@','signf'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.sign(int);
CREATE OR REPLACE FUNCTION PUBLIC.sign(int)
RETURNS int
AS '@libdir@/regress@DLSUFFIX@','signi'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.rpad(text, numeric, text);
CREATE OR REPLACE FUNCTION PUBLIC.rpad(text, numeric, text default ' ')
RETURNS text
AS '@libdir@/regress@DLSUFFIX@','rpad_f'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.round(int, int);
CREATE OR REPLACE FUNCTION PUBLIC.round(int, int default 0)
RETURNS int
AS '@libdir@/regress@DLSUFFIX@','RoundInt'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.round(float, int);
CREATE OR REPLACE FUNCTION PUBLIC.round(float, int default 0)
RETURNS numeric
AS 'select pg_catalog.round($1::numeric,$2)'
LANGUAGE SQL IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.round(numeric, int);
CREATE FUNCTION PUBLIC.round(numeric, int default 0) RETURNS numeric
	AS 'SELECT CASE WHEN $2<6 THEN pg_catalog.round($1, $2) ELSE pg_catalog.round(pg_catalog.round($1, $2), 5) END'
LANGUAGE SQL strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.oreplace;
CREATE OR REPLACE FUNCTION PUBLIC.oreplace(VARCHAR(16000), VARCHAR(512), VARCHAR(512) default '')
RETURNS VARCHAR(16000)
AS 'select pg_catalog.replace($1,$2, $3)'
LANGUAGE SQL IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.NormsDistInner;
CREATE OR REPLACE FUNCTION PUBLIC.NormsDistInner(NUMERIC)
RETURNS NUMERIC
AS '@libdir@/regress@DLSUFFIX@','normsdist'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.NormsDist;
CREATE FUNCTION PUBLIC.NormsDist(NUMERIC(18,15)) RETURNS NUMERIC(18,15)
    AS 'select public.NormsDistInner($1)::NUMERIC(18,15)'
LANGUAGE SQL strict IMMUTABLE;


--
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(date, date);
CREATE OR REPLACE FUNCTION PUBLIC.months_between_inner(date, date)
RETURNS FLOAT4
AS '@libdir@/regress@DLSUFFIX@','months_between_dd'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.months_between(date, date);
CREATE OR REPLACE FUNCTION PUBLIC.months_between(date, date) RETURNS NUMERIC(18,2)
    AS 'select (public.months_between_inner($1, $2)::float)::NUMERIC(18,2)'
LANGUAGE SQL strict IMMUTABLE;

--		
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(date, timestamp);
CREATE OR REPLACE FUNCTION PUBLIC.months_between_inner(date, timestamp)
RETURNS FLOAT4
AS '@libdir@/regress@DLSUFFIX@','months_between_dt'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.months_between(date, timestamp);
CREATE OR REPLACE FUNCTION PUBLIC.months_between(date, timestamp) RETURNS NUMERIC(18,2)
    AS 'select (public.months_between_inner($1, $2)::float)::NUMERIC(18,2)'
LANGUAGE SQL strict IMMUTABLE;

--
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(timestamp, date);
CREATE OR REPLACE FUNCTION PUBLIC.months_between_inner(timestamp, date)
RETURNS FLOAT4
AS '@libdir@/regress@DLSUFFIX@','months_between_td'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.months_between(timestamp, date);
CREATE OR REPLACE FUNCTION PUBLIC.months_between(timestamp, date) RETURNS NUMERIC(18,2)
    AS 'select (public.months_between_inner($1, $2)::float)::NUMERIC(18,2)'
LANGUAGE SQL strict IMMUTABLE;

--
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(timestamp, timestamp);
CREATE OR REPLACE FUNCTION PUBLIC.months_between_inner(timestamp, timestamp)
RETURNS FLOAT4
AS '@libdir@/regress@DLSUFFIX@','months_between_tt'
LANGUAGE c strict IMMUTABLE;

DROP FUNCTION IF EXISTS PUBLIC.months_between(timestamp, timestamp);
CREATE OR REPLACE FUNCTION PUBLIC.months_between(timestamp, timestamp) RETURNS NUMERIC(18,2)
    AS 'select (public.months_between_inner($1, $2)::float)::NUMERIC(18,2)'
LANGUAGE SQL strict IMMUTABLE;


DROP FUNCTION IF EXISTS PUBLIC.lpad(text, numeric, text);
CREATE OR REPLACE FUNCTION PUBLIC.lpad(text, numeric, text default ' ')
RETURNS text
AS '@libdir@/regress@DLSUFFIX@','lpad_f'
LANGUAGE c strict IMMUTABLE;



DROP FUNCTION IF EXISTS public.FUNC_III_CS0507_3;
CREATE  FUNCTION FUNC_III_CS0507_3(in NUMERIC(18,4))
returns text
as '@libdir@/regress@DLSUFFIX@','FUNC_III_CS0507_3'
language c IMMUTABLE;

DROP FUNCTION IF EXISTS public.FUNC_III_CS0507;
CREATE  FUNCTION FUNC_III_CS0507(in NUMERIC(18,4))
returns text
as '@libdir@/regress@DLSUFFIX@','FUNC_III_CS0507'
language c IMMUTABLE;

DROP FUNCTION IF EXISTS public.FUNC_II_JUDGE_DF_AGE;
CREATE  FUNCTION FUNC_II_JUDGE_DF_AGE(in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4), in NUMERIC(18,4))
returns int
as '@libdir@/regress@DLSUFFIX@','FUNC_II_JUDGE_DF_AGE'
language c IMMUTABLE;


-- FUNC_TRANS_MOBCODE
DROP FUNCTION IF EXISTS public.FUNC_TRANS_MOBCODE;
CREATE  FUNCTION FUNC_TRANS_MOBCODE(in NUMERIC(18,4))
returns text
as '@libdir@/regress@DLSUFFIX@','FUNC_TRANS_MOBCODE'
language c IMMUTABLE;

-- FUNC_TRANS_RISKCODE
DROP FUNCTION IF EXISTS public.FUNC_TRANS_RISKCODE;
CREATE  FUNCTION FUNC_TRANS_RISKCODE(in text, in NUMERIC(18,4))
returns text
as '@libdir@/regress@DLSUFFIX@','FUNC_TRANS_RISKCODE'
language c IMMUTABLE;

-- FUNC_XW_FIX_DPD
DROP FUNCTION IF EXISTS public.FUNC_XW_FIX_DPD;
CREATE  FUNCTION FUNC_XW_FIX_DPD(in text, in NUMERIC(18,4))
returns int
as '@libdir@/regress@DLSUFFIX@','FUNC_XW_FIX_DPD'
language c IMMUTABLE;

-- FUNC_ZERO_NULL
DROP FUNCTION IF EXISTS public.FUNC_ZERO_NULL;
CREATE  FUNCTION FUNC_ZERO_NULL(in NUMERIC(18,4))
returns NUMERIC(18,4)
as '@libdir@/regress@DLSUFFIX@','FUNC_ZERO_NULL'
language c strict IMMUTABLE;



DROP FUNCTION IF EXISTS PUBLIC.trunc(int);
DROP FUNCTION IF EXISTS PUBLIC.trunc(int, int);
DROP FUNCTION IF EXISTS PUBLIC.trunc(float4, int);
DROP FUNCTION IF EXISTS public.trunc(numeric, int);
DROP FUNCTION IF EXISTS PUBLIC.TransDate(varchar(50), int, varchar(50));
DROP FUNCTION IF EXISTS PUBLIC.TransTimestamp(varchar(50), int, varchar(50));
DROP FUNCTION IF EXISTS PUBLIC.sign(float4);
DROP FUNCTION IF EXISTS PUBLIC.sign(int);
DROP FUNCTION IF EXISTS PUBLIC.rpad(text, numeric, text);
DROP FUNCTION IF EXISTS PUBLIC.round(int, int);
DROP FUNCTION IF EXISTS PUBLIC.round(float, int);
DROP FUNCTION IF EXISTS PUBLIC.round(numeric, int);
DROP FUNCTION IF EXISTS PUBLIC.oreplace;
DROP FUNCTION IF EXISTS PUBLIC.NormsDistInner;
DROP FUNCTION IF EXISTS PUBLIC.NormsDist;
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(date, date);
DROP FUNCTION IF EXISTS PUBLIC.months_between(date, date);
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(date, timestamp);
DROP FUNCTION IF EXISTS PUBLIC.months_between(date, timestamp);
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(timestamp, date);
DROP FUNCTION IF EXISTS PUBLIC.months_between(timestamp, date);
DROP FUNCTION IF EXISTS PUBLIC.months_between_inner(timestamp, timestamp);
DROP FUNCTION IF EXISTS PUBLIC.months_between(timestamp, timestamp);
DROP FUNCTION IF EXISTS PUBLIC.lpad(text, numeric, text);
DROP FUNCTION IF EXISTS PUBLIC.FUNC_JUDGE_ACC;
DROP FUNCTION IF EXISTS PUBLIC.FUNC_GREAST_MOB24;
DROP FUNCTION IF EXISTS public.FUNC_AGE_JUDGE;
DROP FUNCTION IF EXISTS public.FUNC_CAP;
DROP FUNCTION IF EXISTS public.FUNC_COST_SERVICE;
DROP FUNCTION IF EXISTS public.FUNC_DIV_CIIS_DATA_100_inner;
DROP FUNCTION IF EXISTS public.FUNC_DIV_CIIS_DATA_100;
DROP FUNCTION IF EXISTS public.FUNC_DIV_CIIS_DATA_ZERO_inner;
DROP FUNCTION IF EXISTS public.FUNC_DIV_CIIS_DATA_ZERO;
DROP FUNCTION IF EXISTS public.FUNC_DIV_DATA_inner;
DROP FUNCTION IF EXISTS public.FUNC_DIV_DATA;
DROP FUNCTION IF EXISTS public.FUNC_DIV_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_DIV_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_DIV_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_DIV_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_DPT_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_DPTADD_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_FOUR_SEG;
DROP FUNCTION IF EXISTS public.FUNC_GREAST_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_GREAST_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_GREAST_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_II_CL_DPM_CAST;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_NULL_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_NULL_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_NULL_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_NULL_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_II_CL_SUM_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_CL_SUM_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_CL_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_CL_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_VAR_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_VAR_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_VAR_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_CEIL_DATA_inner;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_CEIL_DATA;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_DATA_inner;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_DATA;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_DATA_NULL_inner;
DROP FUNCTION IF EXISTS public.FUNC_II_DIV_DATA_NULL;
DROP FUNCTION IF EXISTS public.FUNC_II_DPM_QC_MIN1;
DROP FUNCTION IF EXISTS public.FUNC_II_FLOOR_ZERO;
DROP FUNCTION IF EXISTS public.FUNC_III_CS0507_2;
DROP FUNCTION IF EXISTS public.FUNC_II_GREAST_VAR_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_III_CS0507_3;
DROP FUNCTION IF EXISTS public.FUNC_III_CS0507;
DROP FUNCTION IF EXISTS public.FUNC_II_JUDGE_DF_AGE;
DROP FUNCTION IF EXISTS public.FUNC_II_LEAST_CL_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_LEAST_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_II_LEAST_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_LEAST_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_LEAST_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_II_LEAST_VAR_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_II_SUM_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_II_SUM_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_II_SUM_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_II_SUM_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_3;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_6;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_9;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_12;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_15;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_18;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_21;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_ACC_24;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_EAD;
DROP FUNCTION IF EXISTS public.FUNC_JUDGE_NUMBER;
DROP FUNCTION IF EXISTS public.FUNC_LEAST_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_LEAST_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_LEAST_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_MINROC_AMOUNT;
DROP FUNCTION IF EXISTS public.FUNC_MINROC_NUM;
DROP FUNCTION IF EXISTS public.FUNC_MONTH_FLAG_BANNIAN;
DROP FUNCTION IF EXISTS public.FUNC_MONTH_FLAG_JI;
DROP FUNCTION IF EXISTS public.FUNC_OVE_MONTH_CODE;
DROP FUNCTION IF EXISTS public.FUNC_PRICE_CODE;
DROP FUNCTION IF EXISTS public.FUNC_SUM_MOB3;
DROP FUNCTION IF EXISTS public.FUNC_SUM_MOB6;
DROP FUNCTION IF EXISTS public.FUNC_SUM_MOB9;
DROP FUNCTION IF EXISTS public.FUNC_SUM_MOB12;
DROP FUNCTION IF EXISTS public.FUNC_TRANS_MOBCODE;
DROP FUNCTION IF EXISTS public.FUNC_TRANS_RISKCODE;
DROP FUNCTION IF EXISTS public.FUNC_XW_FIX_DPD;
DROP FUNCTION IF EXISTS public.FUNC_ZERO_NULL;