Search Postgresql Archives
Function Volatility Stable vs Immutable
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Function Volatility Stable vs Immutable
- From: "Igal @ Lucee.org" <igal@xxxxxxxxx>
- Date: Mon, 24 Jun 2019 19:31:27 -0700
- User-agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.7.2
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]