Re: Question about simple function folding optimization

Tom Lane wrote:
> Hmm.  That's an unexpected downside of the recent change to inline
> simple SQL functions :-(.  The inlined expression no longer looks
> like a match to the index.
> 
> The simplest answer is probably to convert the function to plpgsql,
> which would probably give better performance for index access anyway.
> But I wonder whether any better answer is possible.  I don't want to
> give up on the inlining optimization --- anyone see another fix?
> 

Would changing the function from immutable to stable work (similar to 
the other day)?

Joe