Function Volatility Stable vs Immutable

From: "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Function Volatility Stable vs Immutable
Date: 2019-06-25 02:31:27
Message-ID: 8a4ed1a2-74de-0fa3-e2a2-7b68b60b0a4f@lucee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2019-06-25 02:38:33 Re: Function Volatility Stable vs Immutable
Previous Message Prakash Ramakrishnan 2019-06-25 01:42:54 minor upgrade