Is there a way in pg to fire a function when a complete (not row by row) set is updated/inserted/deleted, for instance.
update order_detail set confirmed='S' where modifieddate=current_date;
Then after all the affected rows are updated, I need some code to uptaded other tables from the information of the updated rows in the details table.
Thanks in advance.
-- Sinceramente, Josué Maldonado.
"Cuando los ricos se hacen la guerra, son los pobres los que mueren." Jean Paul Sartre. Filósofo y escritor francés.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html