"John D. Burger" <john@xxxxxxxxx> writes: > I'm having trouble figuring out when (if) the planner inlines sql > functions (I'm running 7.4). I was assuming that pure sql functions > are kind of like views with parameters, but I can't seem to see any > cases where functions that select from a table get inlined. That's 'cause there aren't any ... especially not in 7.4 ... we inline simple scalar functions of the form "select scalar-expression" but that's about it. regards, tom lane