달력넣기

do $$
declare
    v_day integer;
    v_date integer;
    v_week integer;
    v_hol  varchar;
begin
    v_day = 1; 
    v_date = 5;  -- 0(SUN) 1 2 3 4 5 6(SAT) 
    v_week = 1;

    for i in 1..365 loop
        if v_date % 7 = 0 then
            v_week:= v_week + 1;
        end if;

        if (v_date % 7 = 6) or (v_date % 7 = 0) then
            v_hol:='Y';
        else 
            v_hol:= 'N';
        end if;

/*        insert / select statement */

        v_date := v_date+1;
    end loop;          

end $$;