Re: How do a user-defined function that returns a table executes a query?

2023-02-08 Thread Katsuya Okizaki
you for your valuable advice. Best regards, Katsuya Okizaki 2023年2月8日(水) 19:18 Laurenz Albe : > On Wed, 2023-02-08 at 08:49 +0900, Katsuya Okizaki wrote: > > In a normal SQL, we can use the EXPLAIN command to view the execution > plan. > > However, in this case, I am not sure

Re: How do a user-defined function that returns a table executes a query?

2023-02-08 Thread Katsuya Okizaki
Dear David, Thank you for your prompt reply. This is exactly what I was looking for. Thank you for your help. Best regards, Katsuya Okizaki 2023年2月8日(水) 8:51 David G. Johnston : > On Tue, Feb 7, 2023 at 4:49 PM Katsuya Okizaki > wrote: > >> In a normal SQL, we can use the EXP

How do a user-defined function that returns a table executes a query?

2023-02-07 Thread Katsuya Okizaki
Hi everyone, I hope this message finds you in good health and spirits. I am reaching out to this incredible community for some guidance and advice. I am currently trying to understand how a user-defined function that returns a table executes a query. In a normal SQL, we can use the EXPLAIN comman