| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | stan <stanb(at)panix(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Variable constants ? |
| Date: | 2019-08-15 21:09:42 |
| Message-ID: | f67cc235-49ce-176b-0e15-9a09f1c647c2@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/15/19 1:56 PM, stan wrote:
> I need to put a few bossiness constants, such as a labor rate multiplier in an
> application. I am adverse to hard coding these things. The best plan i have
> come up with so far is to store them in a table, which would have only 1
> row, and a column for each needed constant.
>
> Anyone have a better way to do this?
Another way(better in eye of beholder) a conf file that can be written to.
>
> Failing a better way is there some way I can limit this table to only allow
> one row to exist?
Yes add the row and REVOKE INSERT afterwards. Then you have a single row
that can be updated/deleted(though you could revoke that also).
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2019-08-15 21:27:26 | Re: Variable constants ? |
| Previous Message | stan | 2019-08-15 20:56:57 | Variable constants ? |