Re: Help with CREATE FUNCTION - Mailing list pgsql-novice

From Tom Lane
Subject Re: Help with CREATE FUNCTION
Date
Msg-id 1621.1461003577@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help with CREATE FUNCTION  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Help with CREATE FUNCTION
List pgsql-novice
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Monday, April 18, 2016, Kip Warner <kip@thevertigo.com> wrote:
>> They are pre-calculated constants that are part of a more complex
>> algorithm. I can't submit them when I install the database schema
>> because they may change later

> There is no provision in PostgreSQL for constructing a global variable in
> that fashion.  You could maybe leverage GUCs to that effect, though.

If they might change later, they're not really constants, hm?  The
usual advice for this sort of thing is to store them in a table.

            regards, tom lane


pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Help with CREATE FUNCTION
Next
From: Kip Warner
Date:
Subject: Re: Help with CREATE FUNCTION