Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table existing_table as select 1::int8 a, 2::int8 b;

SELECT 1


CREATE OR REPLACE FUNCTION sp_str_dsl_lp_ung(color smallint,
lpcount integer, update_userid character varying, OUT lp integer)
RETURNS integer
LANGUAGE plpgsql volatile
AS $function$
declare 

--variables
variab int :=0;
begin  

    CREATE temporary TABLE temp_table  (a int8, b int8) ;
    insert into temp_table (a,b) select a,b from existing_table;
end
$function$

CREATE FUNCTION


DO $$
DECLARE
l_lp INTEGER;
BEGIN
  l_lp := sp_str_dsl_lp_ung(1::smallint,10,'ID1'::varchar)    ;
END $$;

DO


select * from temp_table;


a
b


1
2



SELECT 1