get_lbb_rev_jasa

CREATE OR REPLACE FUNCTION public.get_lbb_rev_jasa(mon character varying, thn character varying, kodeahass character varying)
 RETURNS TABLE(totalrev double precision, jasakpb double precision, jasapm double precision, jasalr double precision, jasahr double precision, jasaclaim double precision, jasams double precision)
 LANGUAGE plpgsql
AS $function$
begin
	RETURN QUERY
	select *
	from dblink('dbname=ddmsh2_cbr host=localhost user=ddmsh2app password=bandungh1h2h3 port=5432'::text, 
			format('SELECT * FROM get_lbb_rev_jasa_v3(%L, %L, %L)', mon, thn, kodeahass)) wo
			(totalrev double precision, jasakpb double precision, jasapm double precision, jasalr double precision, jasahr double precision, jasaclaim double precision, jasams double precision);
end;
$function$
;
;