Saturday 8 August 2020

How To Create A Stored Function In PostgreSQL And Call Stored Function I...




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();



CREATE OR REPLACE FUNCTION public.testing_function()



RETURNS text

LANGUAGE 'plpgsql'



COST 100

VOLATILE



AS $BODY$



DECLARE

v_return_msg text;

BEGIN



v_return_msg := 'Hello Akram';



return v_return_msg;



END;

$BODY$;


No comments:

Post a Comment