Tom Lane writes:
> The IMMUTABLE marker is a promise from you to the system that it is safe
> to optimize away multiple calls to the function. It is not a promise
> from the system to you that the system will expend unlimited amounts of
> energy to detect duplicate calls.
Nicely put. Thanks!
BTW
"Fernando Hevia" <[EMAIL PROTECTED]> writes:
> I am not sure if I am understanding volatility.
You're not.
> What bother me are the 3 "been here" messages. As the function is immutable
> and the parameter remains unchanged needs the planner actually execute the
> function 3 times?
The IMMUTABLE
Hi guys,
I am not sure if I am understanding volatility.
My issue is better explained with a quick example. The function below
expresses call durations in minutes and it is immutable.
CREATE OR REPLACE FUNCTION dur2min(secs INTEGER) RETURNS INTEGER
AS $$
BEGIN
RAISE NOTICE 'BEEN HERE!';
