Re: Insert Table from Execute String Query

2019-12-06 Thread Adrian Klaver
On 12/6/19 1:00 AM, İlyas Derse wrote: I need to insert temp table from execute string query. How can I do ? I'm trying like that but not working. CREATE OR REPLACE FUNCTION public.testdyn (         x integer ) RETURNS TABLE (         id bigint,         text character varying(4000) ) AS $$

Insert Table from Execute String Query

2019-12-06 Thread İlyas Derse
I need to insert temp table from execute string query. How can I do ? I'm trying like that but not working. CREATE OR REPLACE FUNCTION public.testdyn ( x integer ) RETURNS TABLE ( id bigint, text character varying(4000) ) AS $$ DECLARE mysql TEXT; BEGIN crea