Untitled

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