Re: Documenting inlining SQL functions - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Documenting inlining SQL functions
Date
Msg-id CAKFQuwYD_vuW42N_+4gFQrsrp7iJN2Kg5rOq8jRAHGWhn32tOA@mail.gmail.com
Whole thread Raw
In response to Documenting inlining SQL functions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Documenting inlining SQL functions
List pgsql-hackers
On Sunday, July 6, 2025, Paul Jungwirth <pj@illuminatedcomputing.com> wrote:
The second patch adds a new <sect2> explaining how we inline SQL functions: both single-result and set-returning. Since this happens automatically, it makes a nice progression with the (easy) declarative annotations and the (hard) support functions.

The fact that attaching a set clause to the function definition (i.e., proconfig) prevents inlining is missing from this description.

David J.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: index prefetching
Next
From: Tom Lane
Date:
Subject: Re: Documenting inlining SQL functions