Обсуждение: PLPGSQL: DECLARE more variable with same type at once

Поиск
Список
Период
Сортировка

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

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

От
"David G. Johnston"
Дата:
On Wednesday, March 25, 2020, Durumdara <durumdara@gmail.com> 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.

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

От
Pavel Stehule
Дата:


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