Subject: Re: Execute command in PL/pgSQL function not executing
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Fri, 19 Nov 2021 19:24:46 -0700
Cc: "David G. Johnston" <david.g.johnston@xxxxxxxxx>, Abdul Mohammed <imonikemohammed@xxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, Pavel Stehule <pavel.stehule@xxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
You could also just return the name of the temp table, or return nothing and directly use that name manually outside the function to do select * from pg_temp.my_data
