Why does the postgresql function return an integer?

CREATE OR REPLACE FUNCTION get_zp(zp real default 70) RETURNS real AS $$
DECLARE
    percent_zp real := 0.15;
    zp_new real;
BEGIN
    IF zp > 70 THEN  zp_new = zp;
    ELSIF zp < 0 THEN  zp_new = zp;
    ELSE zp_new = zp * percent_zp+zp;
    END IF;
    RETURN zp_new;
END;
$$ LANGUAGE plpgsql;

execute

select * from get_zp(50);

why does the function return 50???


Ответы (0 шт):