På onsdag 27. mai 2015 kl. 12:42:29, skrev Marko Tiikkaja <
marko@joh.to>:
On 5/27/15 12:39 PM, Jordan Gigov wrote:
> I found myself in need of triggers that are run only once per transaction,
> rather than per row or statement within the transaction. Meaning it will
> always be deferred and never called twice for the same transaction.
What's the use case?
I've often needed this for stuff like:
UPDATE some_table SET col = 'foo' where id = 1;
UPDATE some_table SET col = 'bar' where id = 1;
I want the "on-tx"-trigger to only run once, and on the last update of "col" so that it sees 'bar'.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS