高斯数据库函数定义

--删除并重建函数
DROP FUNCTION IF EXISTS F_GET_AGE_NAME_BY_IDNUMBER(VARCHAR);
CREATE OR REPLACE FUNCTION F_GET_BIRTH_BY_IDNUMBER(IN_ID_NUMBER VARCHAR)
RETURNS DATE
AS
$$
DECLARE
    V_RESULT DATE;
BEGIN
    SELECT to_date(substr(IN_ID_NUMBER, 7, 8), 'yyyy-MM-dd') INTO V_RESULT;
    RETURN V_RESULT;
END;
$$
LANGUAGE plpgsql;