How To Create A Parameterized Stored Function In PostgreSQL || Pass Para...

Only 3.9% of viewers are subscribing to my channel 😓.

I request you to please give click on Subscribe button.

It really helps me grow 😢.

SELECT public.testing_function(101,'Hello Akram');


CREATE OR REPLACE FUNCTION public.testing_function(p_num numeric,p_msg text)



RETURNS text

LANGUAGE 'plpgsql'



COST 100

VOLATILE



AS $BODY$



DECLARE

v_return_msg text;

BEGIN



v_return_msg := p_msg ||' '||p_num;



return v_return_msg;



END;

$BODY$;