A stored procedure shine jeri na SQL statements (da procedural logic) wanda aka ajiye a cikin database kuma ana aiwatarwa ta suna. Yana aiwatar da logic a cikin database maimakon a cikin application code. Suna da kyakkyawan amfani ainihi amma kuma suna da manyan jiya-jiya, saboda haka yaushe za ka yi amfani da su shine ainihin shawarwarin zane.
A stored procedure
transfer_funds(from_id , to_id , amount )
plpgsql $$
accounts balance balance amount id from_id;
accounts balance balance amount id to_id;
;
$$;
transfer_funds(, , );
