Hi everyone, I would like to know how can i do a simple transaction for this situation:
I have n products in certain row of a table. When the user buys a product, the quantity of this product will be decreased. The user can only buy a product that has a quantity n > 0. This means that when the user send the product confirmation to the system, the bd will decrease the product quantity with a transaction if the number of product in stock is greater than zero. Did anyone knows how can i do that with postgre? Thanks a lot.
