Guidance with trigger and Procedures: I want to update an attribute stock_quantity on the products table, as i insert the sale in sales table
I building a data base for ecommerce in postgresql and i would like to update the quantity as soon as make the sales to make the system more accurate.