Shared Constants in PLPGSQL

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Shared Constants in PLPGSQL
Date: 2017-08-01 09:56:02
Message-ID: CAGuHJrNipwCVQx5RYLjdF5CEk_cgeSMimZ_aGwk_5B2_wEOusg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober@computer.org 2017-08-01 11:57:59 Re: Shared Constants in PLPGSQL
Previous Message Murtuza Zabuawala 2017-08-01 07:39:45 Not able to create collation on Windows