"John D. Burger" <john@mitre.org> 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