Postgres Pro
Downloads
Home   >   mailing lists

Re: PLPGSQL: DECLARE more variable with same type at once - Mailing list pgsql-general

From Pavel Stehule
Subject Re: PLPGSQL: DECLARE more variable with same type at once
Date
Msg-id CAFj8pRCQMScbrX1gQLkKRVEOdWmKfZ4p6A-w64zLDpX7R+J7Pg@mail.gmail.com
Whole thread Raw
In response to PLPGSQL: DECLARE more variable with same type at once  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view


st 25. 3. 2020 v 13:53 odesílatel Durumdara <durumdara@gmail.com> 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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PLPGSQL: DECLARE more variable with same type at once
Next
From: Ekaterina Amez
Date:
Subject: Re: How to plpgsql scripting