Oliver Jowett <oliver@opencloud.com> writes:
> Bruno Wolff III wrote:
>> I should have said within a single statement instead of within a single
>> transaction.
> As I understand Tom's earlier explanation of this, the definition is
> even more narrow: stable functions only need to return the same value
> across a single tablescan.
> It might be useful to have some variant of stable (or perhaps just a
> change in semantics) such that the function returns the same value for
> identical parameters until the next CommandCounterIncrement.
In practice I think these are equivalent definitions.
regards, tom lane