Adam Brusselback wrote:
> I appreciate the response Tom, and you are correct that the workaround would not work in my case.
>
> So no index expressions can return the their value without recomputing without that work around? I
> learn something new every day it seems.
> Thank you for the alternate method.
No, what Tom said is that the check whether an "index only scan" was feasible
or not does not consider expressions.
Yours,
Laurenz Albe