Postgresql 프로시저 만들기

CREATE OR REPLACE FUNCTION public.sp2_test(test character varying, OUT out_msg character varying)

RETURNS character varying

LANGUAGE sql

AS $function$

declare

BEGIN

EMD;

EXCEPTION

  WHEN OTHERS THEN

       OUT_MSG:=SQLERRM;

END;

$function$