get_lbb_rev_jasa

mail@pastecode.io avatar
unknown
mysql
a month ago
792 B
3
Indexable
Never
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$
;
;
Leave a Comment