CREATE OR REPLACE FUNCTION minus_satu_bln(tgl date)untuk execute function tersebut adalah seperti berikut :
RETURNS numeric AS
$BODY$
DECLARE
BULAN NUMERIC;
BEGIN
IF EXTRACT(MONTH FROM TGL) = 1 THEN
BULAN = 12;
ELSE
BULAN = EXTRACT(MONTH FROM TGL) - 1;
END IF;
RETURN BULAN;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION minus_satu_bln(date)
OWNER TO postgres;
Post a Comment