Function Volatility Stable vs Immutable - Mailing list pgsql-general

From Igal @ Lucee.org
Subject Function Volatility Stable vs Immutable
Date
Msg-id 8a4ed1a2-74de-0fa3-e2a2-7b68b60b0a4f@lucee.org
Whole thread Raw
Responses Re: Function Volatility Stable vs Immutable
List pgsql-general
If a function select data from a table, and the rows in the table may 
change, would that function qualify for Immutable or does it have to be 
Stable?  I'm asking because according to the docs [1]: "An IMMUTABLE 
function cannot modify the database and is guaranteed to return the same 
results given the same arguments forever".

So for the same arguments, the result would change only if the data in 
the table changes.  Does that mean that it violates the "forever" clause 
and therefore can be only marked as Stable and not Immutable?

Thanks,

Igal





pgsql-general by date:

Previous
From: Prakash Ramakrishnan
Date:
Subject: minor upgrade
Next
From: "David G. Johnston"
Date:
Subject: Re: Function Volatility Stable vs Immutable