Re: [GENERAL] Convincing STABLE functions to run once

2014-09-09 Thread Alban Hertroys
On 09 Sep 2014, at 17:23, Dan Wells wrote: > I often have functions which are not truly immutable (they do something > minor, like read in configuration information), but the functions themselves > are fairly expensive, so I want them to run just once per query. At face > value, I feel like S

Re: [GENERAL] Convincing STABLE functions to run once

2014-09-09 Thread Merlin Moncure
On Tue, Sep 9, 2014 at 10:23 AM, Dan Wells wrote: > Hello all, > > I’ve run into this issue in several contexts recently, and wonder if folks > here can help clear up my understanding of function volatility. I often > have functions which are not truly immutable (they do something minor, like > r

Re: [GENERAL] Convincing STABLE functions to run once

2014-09-09 Thread Tom Lane
Dan Wells writes: > I've run into this issue in several contexts recently, and wonder if > folks here can help clear up my understanding of function volatility. I > often have functions which are not truly immutable (they do something > minor, like read in configuration information), but the func

[GENERAL] Convincing STABLE functions to run once

2014-09-09 Thread Dan Wells
Hello all, I've run into this issue in several contexts recently, and wonder if folks here can help clear up my understanding of function volatility. I often have functions which are not truly immutable (they do something minor, like read in configuration information), but the functions themse