Function Volatility Stable vs Immutable

Поиск
Список
Период
Сортировка
От Igal @ Lucee.org
Тема Function Volatility Stable vs Immutable
Дата
Msg-id 8a4ed1a2-74de-0fa3-e2a2-7b68b60b0a4f@lucee.org
обсуждение исходный текст
Ответы Re: Function Volatility Stable vs Immutable  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Prakash Ramakrishnan
Дата:
Сообщение: minor upgrade
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Function Volatility Stable vs Immutable