pour insertion devis

-- condition pour insertion devis --

no_a_renvoyer INTEGER := 0;
    no_a_verifier INTEGER := 0;
    date_1 DATE := CAST(date_propo AS DATE);
    date_verif DATE := date_propo - 7 * INTERVAL '1 day';
    date_punition TIMESTAMP := NULL;

SELECT date_punishment INTO date_punition FROM projetsql.maisons WHERE no_maison = num_house;

    IF(masked = 'true')THEN
        IF EXISTS (SELECT d.no_devis FROM projetsql.devis d WHERE CAST(date_emission AS DATE)= date_1 AND devis_masque = TRUE AND no_maison = num_house) THEN RETURN no_a_renvoyer;
        END IF;
    END IF;
    IF(mask = 'true')THEN
        IF EXISTS (SELECT d.no_devis FROM projetsql.devis d WHERE CAST(date_emission AS DATE) BETWEEN date_verifdate_1 AND date_1 AND devis_masquant = TRUE AND no_maison = num_house)THEN RETURN no_a_renvoyer;
        END IF;
        IF( date_propo < date_punition + INTERVAL '1 day') THEN RETURN no_a_renvoyer;
        END IF;

    END IF;