Re: stable functions

2007/5/31, Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com>:

> Nonetheless your remark makes a lot of sense and I'm still in dubt.
> In my case the "creatorfunc" has no parameters and returns void as it reads
> data from configuration tables.
> And it should be OK if ti were run only once.

AFAIK, the only practical sense of defining functions as
stable/immutable is the runtime query optimization.
If you don't need any optimization, and the function takes no params,
why not leave it as volatile?

> I'd say that some more explaination in the documentatio would be great under
> "33.6. Function Volatility Categories".
For me it's clear enough.

--
Filip Rembiałkowski