PLPGSQL: DECLARE more variable with same type at once

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

PLPGSQL: DECLARE more variable with same type at once

durumdara
Hello!

I want to ask how to shortening code?

    Delta double precision;
    UjErtek double precision;
    UjDErtek double precision;

For example - but this makes an error:
    Delta, UjErtek, UjDErtek double precision;

Do you know any other form?

Thank you for it!

Best regards
   dd
Reply | Threaded
Open this post in threaded view
|

Re: PLPGSQL: DECLARE more variable with same type at once

David G Johnston
On Wednesday, March 25, 2020, Durumdara <[hidden email]> wrote:
Hello!

I want to ask how to shortening code?

    Delta double precision;
    UjErtek double precision;
    UjDErtek double precision;

For example - but this makes an error:
    Delta, UjErtek, UjDErtek double precision;

Do you know any other form?


No other form is specified in the documentation.

David J.
Reply | Threaded
Open this post in threaded view
|

Re: PLPGSQL: DECLARE more variable with same type at once

Pavel Stehule
In reply to this post by durumdara


st 25. 3. 2020 v 13:53 odesílatel Durumdara <[hidden email]> napsal:
Hello!

I want to ask how to shortening code?

    Delta double precision;
    UjErtek double precision;
    UjDErtek double precision;

For example - but this makes an error:
    Delta, UjErtek, UjDErtek double precision;

Do you know any other form?

Short form not supported, because it is not supported in PLpgSQL origin - PL/SQL

Regards

Pavel

Thank you for it!

Best regards
   dd