Re: Execute command in PL/pgSQL function not executing
From:
Michael Lewis <mlewis(at)entrata(dot)com>
To:
Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc:
"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Abdul Mohammed <imonikemohammed(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject:
Re: Execute command in PL/pgSQL function not executing
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