Re: Declare variable from other variable - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Declare variable from other variable
Date
Msg-id 29b33c88-102f-f0d3-3744-af53df41cb8b@gmx.net
Whole thread Raw
In response to Declare variable from other variable  (Raul Kaubi <raulkaubi@gmail.com>)
List 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.



pgsql-general by date:

Previous
From: Yasin Sari
Date:
Subject: Re: Declare variable from other variable
Next
From: Raul Kaubi
Date:
Subject: Re: Declare variable from other variable