Re: [GENERAL] SQL function inlining

2006-10-19 Thread Tom Lane
"John D. Burger" <[EMAIL PROTECTED]> 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 fro

[GENERAL] SQL function inlining

2006-10-19 Thread John D. Burger
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. For instance: create func