Greenplum (Pg 8.2 based) -- Function that performs 3 statements

152 Views Asked by At

I'm using Greenplum and I just want to create a function that performs 1 truncate and 2 selects. This is what I have but it is not working

CREATE OR REPLACE FUNCTION public.pe_GP3()
 RETURNS void
 LANGUAGE plpgsql
AS $function$     
Begin 
truncate table public.pe_new;
select public.peGP();
select public.peGP2();
END;
$function$
0

There are 0 best solutions below