Annotation: transactions.create_routine

CREATE OR REPLACE FUNCTION transactions.create_routine(_routine_code character varying, _routine regproc, _order integer)
RETURNS void

Information: transactions.create_routine

Schema	transactions
Function Name	create_routine
Arguments	_routine_code character varying, _routine regproc, _order integer
Owner	postgres
Result Type	void
Description

Implementation: transactions.create_routine

CREATE OR REPLACE FUNCTION transactions.create_routine(_routine_code character varying, _routine regproc, _order integer)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
   INSERT INTO transactions.routines(routine_code, routine_name, "order")
   SELECT $1, $2, $3;
   
   RETURN;
END
$function$