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.