A stored procedure yaiku set saka SQL statements (lan procedural logic) sing disimpen ing database lan dieksekusi kanthi jeneng. Iki njalanake logic ing database tinimbang ing application code. Dheweke duwe benefit sing nyata nanging uga trade-off sing signifikan, dadi kapan nggunakake dheweke yaiku keputusan design sing genuine.
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(, , );
