What's the best way to deal with global constants in PLPGSQL. Currently I
am putting them in a function with out parameters and then calling that
function from every other function that needs them like this.

CREATE OR REPLACE FUNCTION hashids.constants(
     OUT min_alphabet_length integer,
    OUT sep_div numeric,
    OUT guard_div numeric,
    OUT default_steps text,
    OUT default_alphabet text,
    OUT salt text)

I am presuming that if I set this function as immutable the calls to this
function will be cached and will not incur much overhead.

Is there a better way to deal with this?

Reply via email to