Laurenz Albe <laurenz.albe@xxxxxxxxxxx> writes: > Also, to have PostgreSQL inline the function, which would be good > for performance, it should be declared IMMUTABLE. Actually, if you hope to have a SQL function be inlined, it's better not to decorate it at all --- not with IMMUTABLE, and not with STRICT either. Both of those restrict the parser's ability to inline unless it can prove the contained expression is equally immutable/strict. With the default attributes of volatile/not strict, there's nothing to prove. (In any case, it's usually easy enough to tell from EXPLAIN output whether inlining has happened.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
