Re: Alternative to slow SRF in SELECT?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, May 17, 2022 at 7:19 AM Markur Sens <markursens@xxxxxxxxx> wrote:

I have the following  case

select 
	my_srf_func(otherfunc(h))
from (values (‘…’::mytype),

         as temp(h);



Any alternatives on how I could rework the query or the my_srf_func to speed things up, without having too many subqueries? 

Placing the SRF function in the target list is now largely deprecated.  Table producing functions belong in the FROM clause.  The introduction of LATERAL joins made this possible.  My preference is to retain the JOIN syntax.

SELECT *

FROM (...) AS temp (h)

JOIN my_srf_func(h) ON true

David J.