Problem "solved".
"found" will be true of false depending on the trigger action.
update done -> found = true, update not done -> found=false.
But: The trigger sometimes allows updates where no data has been
changed! That is another problem to be solved :(
Regards
walter
Am 25.02.19 um 19:42 s
On 2/25/19 10:42 AM, wambac...@posteo.de wrote:
Hi,
i'm doing a lot of updates in my database, but most of them are not
necessary at all (sorry, just detected it)
Would it not be easier to just not do the unnecessary updates?
Or to put it another way what distinguishes necessary/unnecessary?
Hi,
i'm doing a lot of updates in my database, but most of them are not
necessary at all (sorry, just detected it)
Therefore i installed a trigger to minimize real updates.
create trigger suppress_redundant_updates_boundaries
before update on boundaries
for each row execute procedure suppr
