kingbase 创建函数（date_format、find_in_set）

1 、 date_format函数

CREATE OR REPLACE FUNCTION "public"."date_format"("indate" anyelement, "intext" text)
  RETURNS "pg_catalog"."text" AS $BODY$
BEGIN
IF upper(inText) = upper('%Y%m%d_%H%i') THEN
return to_char(inDate,'YYYYMMDD_HH24MI');
END IF;
IF upper(inText) = upper('%Y%m%d%H%i%s') THEN
return to_char(inDate,'YYYYMMDDHH24MISS');
END IF;
IF upper(inText) = upper('%Y-%m-%d %H:%i:%s') THEN
return to_char(inDate,'YYYY-MM-DD HH24:MI:SS');
END IF;
IF upper(inText) = upper('%Y-%m-%d') THEN
return to_char(inDate,'YYYY-MM-DD');
END IF;
IF upper(inText) = upper('%Y-%m') THEN
return to_char(inDate,'YYYY-MM');
end if;
IF upper(inText) = upper('%m%d') THEN
return to_char(inDate,'MMDD');
END IF;
return '';
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100

2、find_in_set函数

CREATE OR REPLACE FUNCTION "public"."find_in_set"("str" text, "strlist" text)
  RETURNS "pg_catalog"."int4" AS $BODY$
DECLARE b1 VARCHAR;
begin
 b1:=array_position(string_to_array($2, ','),$1); 
 RETURN b1;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100