Re: SQL function inlining - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL function inlining
Date
Msg-id 8304.1161308488@sss.pgh.pa.us
Whole thread Raw
In response to SQL function inlining  ("John D. Burger" <john@mitre.org>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: SQL function inlining
Next
From: "Karl O. Pinc"
Date:
Subject: plpgsql FOUND bug when SELECT INTO assigns a NULL value?