Untitled
unknown
plain_text
18 days ago
352 B
3
Indexable
create or replace function restore_product_quantity() returns trigger as $$ begin update products set quantity = quantity + OLD.quantitysold where productid= old.productid; return old; end; $$ language plpgsql; create trigger after_sale_delete after delete on sales for each row execute function restore_product_quantity();
Editor is loading...
Leave a Comment