Re: Shared Constants in PLPGSQL

On Tue, Aug 1, 2017 at 8:29 AM, Tim Uckun <timuckun(at)gmail(dot)com> wrote:
> In my case I don't expect these constants to be changed on a regular basis.
> They will be set just once and that's it. I was thinking it would be just as
> easy to set them in a proc as it would be to set them in a table. By putting
> them in an immutable proc I can hopefully save a couple of compute cycles.

Sure. The point is, by having a proc return a table based composite
type, you can simplify changes down the line. Adding a new setting
can be done via ALTER. Changing a setting (should it become
necessary) can be done with an UPDATE. The immutable wrapping
function does eliminate some fetches and I would generally write that
wrapper.

merlin