Re: Documenting inlining SQL functions

2025-07-19 Thread Merlin Moncure
On Fri, Jul 18, 2025 at 9:08 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Sunday, July 6, 2025, Paul Jungwirth > wrote: > >> The second patch adds a new explaining how we inline SQL > >> functions: both single-result and set-returning. Since this happens > >> automatically, it makes

Re: Documenting inlining SQL functions

2025-07-18 Thread Pavel Stehule
Hi so 19. 7. 2025 v 5:08 odesílatel Tom Lane napsal: > "David G. Johnston" writes: > > On Sunday, July 6, 2025, Paul Jungwirth > wrote: > >> The second patch adds a new explaining how we inline SQL > >> functions: both single-result and set-returning. Since this happens > >> automatically, it

Re: Documenting inlining SQL functions

2025-07-18 Thread David G. Johnston
On Friday, July 18, 2025, Tom Lane wrote: > "David G. Johnston" writes: > > On Sunday, July 6, 2025, Paul Jungwirth > wrote: > >> The second patch adds a new explaining how we inline SQL > >> functions: both single-result and set-returning. Since this happens > >> automatically, it makes a nic

Re: Documenting inlining SQL functions

2025-07-18 Thread Tom Lane
"David G. Johnston" writes: > On Sunday, July 6, 2025, Paul Jungwirth wrote: >> The second patch adds a new 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

Re: Documenting inlining SQL functions

2025-07-18 Thread David G. Johnston
On Sunday, July 6, 2025, Paul Jungwirth wrote: > > The second patch adds a new 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

Documenting inlining SQL functions

2025-07-18 Thread David G. Johnston
On Friday, July 18, 2025, Maciek Sakrejda wrote: > +1, I think this is very nice to have. I knew about inlining, but not > the details of the mechanism, so it's nice to see when I should expect > it to happen. +1 as well. > > I have some minor wording feedback: > > + And if an extension has h

Re: Documenting inlining SQL functions

2025-07-18 Thread Maciek Sakrejda
+1, I think this is very nice to have. I knew about inlining, but not the details of the mechanism, so it's nice to see when I should expect it to happen. I have some minor wording feedback: + And if an extension has hooked function entry/exit, + then inlining must be skipped. Maybe "And if any

Re: Documenting inlining SQL functions

2025-07-18 Thread Pavel Stehule
Hi po 7. 7. 2025 v 5:12 odesílatel Paul Jungwirth napsal: > Hi Hackers, > > Here are some documentation patches about inlining SQL-language functions. > Postgres has been able to > inline both scalar and set-returning functions since the 9.x days (as long > as they are LANGUAGE SQL > and meet a

Documenting inlining SQL functions

2025-07-06 Thread Paul Jungwirth
Hi Hackers, Here are some documentation patches about inlining SQL-language functions. Postgres has been able to inline both scalar and set-returning functions since the 9.x days (as long as they are LANGUAGE SQL and meet a bunch of other conditions). But this was never documented outside of a