Re: "storing" a calculated value in plsql function ? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: "storing" a calculated value in plsql function ?
Date
Msg-id CAFj8pRAJ5W1XVNTTdGdPG1G2pZbw=YsHeeVVP7x3BOTiaF+W3A@mail.gmail.com
Whole thread Raw
In response to "storing" a calculated value in plsql function ?  (stan <stanb@panix.com>)
List pgsql-general


pá 30. 8. 2019 v 12:48 odesílatel stan <stanb@panix.com> napsal:
I have created a function (PLSQL) that does a complex select with joins on various
tables and views, and returns a table.

In the resultant table, I have raw data, and adjusted data. The adjusted data i
all adjusted by a common factor, which is calculated in the select. Presently, I
calculate this same adjustment factor several times in the select.

Is there a way to reference this value, multiple times, once it is calculated? Or
would I have to create a 2nd select that calculates this adjustment factor, and
stores it in a PLSQL variable< and if I do that, can I reference this stored value
in the select?

you can use custom configuration values like global variables


Regards

Pavel Stehule

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: SSPI auth and mixed case usernames
Next
From: Magnus Hagander
Date:
Subject: Re: SSPI auth and mixed case usernames