| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Kip Warner <kip(at)thevertigo(dot)com>, Sándor Daku <daku(dot)sandor(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Help with CREATE FUNCTION |
| Date: | 2016-04-18 18:19:37 |
| Message-ID: | 1621.1461003577@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Monday, April 18, 2016, Kip Warner <kip(at)thevertigo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kip Warner | 2016-04-18 18:22:29 | Re: Help with CREATE FUNCTION |
| Previous Message | David G. Johnston | 2016-04-18 18:17:53 | Re: Help with CREATE FUNCTION |