CREATE OR REPLACE FUNCTION getAgeReduction(integer, timestamptz) RETURNS numeric AS
                                    
'   DECLARE
    poId Alias for $1;
    DATEOFBIRTH Alias for $2;
    age integer;
    rows integer;
    minOid integer;
   BEGIN
        age := Age(DATEOFBIRTH);
        SELECT ReductionLifeBenefitPercentage INTO AgeReductionPercentage
        FROM (
                SELECT ReductionLifeBenefitPercentage, ReductionLifeBenefitAge
                    FROM(  SELECT ReductionLifeBenefitPercentage, ReductionLifeBenefitAge
                            FROM GroupLifeReduction
                            WHERE planOptionId = poId
                            AND ReductionLifeBenefitAge <= age
                            ORDER BY ReductionLifeBenefitAge DESC) as Sub2
                            WHERE ROWNUM = 1
                        UNION
                            SELECT ReductionLifeBenefitPercentage, ReductionLifeBenefitAge
                            FROM(  SELECT ReductionLifeBenefitPercentage, ReductionLifeBenefitAge
                                    FROM GroupLifeReduction
                                    WHERE planOptionId = poId
                                    AND ReductionLifeBenefitAge >= age
                                    ORDER BY ReductionLifeBenefitAge ASC) AS Sub1
                                    WHERE ROWNUM = 1
                ) AS Sub3 WHERE ROWNUM = 1;
            IF AgeReductionPercentage is null THEN
                return 0;
            ELSE
                return AgeReductionPercentage/100;
            END IF;
   END'
   language 'plpgsql';