> On Dec 19, 2020, at 12:59 AM, Joel Jacobson <joel@xxxxxxxxxxxx> wrote: > > Is there a way to avoid excessive inlining when writing pure SQL functions, without having to use PL/pgSQL? Hi Joel, The rules for inlining are here: https://wiki.postgresql.org/wiki/Inlining_of_SQL_functions According to those rules, if you declared your SQL function as VOLATILE, then Postgres wouldn’t inline it. From your question, I’m not sure if you want to have the same function inlined sometimes and not others. I can’t think of a way to do that offhand. Hope this helps, Philip
