Tom Lane wrote:
Richard Huxton <dev@xxxxxxxxxxxx> writes:I must say I thought recent versions of PG delayed planning the query until first call though.No, you're thinking of parameterized queries sent through the FE/BE protocol. Functions still plan without any assumptions about parameter values.
Ah, fair enough. I *am* right in thinking that trivial SQL functions will have their expressions inlined though?
-- Richard Huxton Archonet Ltd