Writing a Trigger in postgresql with cte and multiple select
I’m working on a Warehouse Database and commodity table.
I have an Inventory_Commodity_log table that has multiple columns as (id, inventory_commodity_id, amount, update_date TIMESTAMP(6),document_type_id BIGINT,….).I should do multiple modification on it: