From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Declare variable from other variable |
Date: | 2020-02-05 12:29:05 |
Message-ID: | 29b33c88-102f-f0d3-3744-af53df41cb8b@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Raul Kaubi schrieb am 05.02.2020 um 12:21:
> How can I declare another variable from another variable.
> Basically from oracle, I can just:
>
> var1 := 'asda'||var2;
>
> In postgres, I have the following example, I would like to use variable j to add number of months there.
>
> " interval 'j month')::date; "
>
>
> 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;
The easiest way is to use make_interval()
v_from_date := (date_trunc('month',current_date) + make_interval(months => j))::date;
But it sounds as if generate_series() is what you are really looking for.
From | Date | Subject | |
---|---|---|---|
Next Message | Raul Kaubi | 2020-02-05 12:42:42 | Re: Declare variable from other variable |
Previous Message | Yasin Sari | 2020-02-05 12:28:25 | Re: Declare variable from other variable |