On Wed, Feb 5, 2020 at 2:22 PM Raul Kaubi <raulkaubi(at)gmail(dot)com> wrote:
>
> DO $$
>> DECLARE
>> v_var integer := 1;
>> v_from_date date;
>> BEGIN
>> for j in 0..v_var LOOP
>> v_from_date := (date_trunc('month',current_date) + interval 'j
>> month')::date;
>> RAISE NOTICE '%', v_from_date;
>> END LOOP;
>> END;
>> $$ LANGUAGE plpgsql;
>
>
>> ERROR: invalid input syntax for type interval: "j month"
>> LINE 1: ...LECT (date_trunc('month',current_date) + interval 'j
>> month')...
>
>
>
>
If you replace red line with this one it will work:
v_from_date := (date_trunc('month',current_date) + interval '1
month'*j)::date;