Unexpected behavior when combining `generated always` columns and update rules

2023-04-13 Thread Ciprian Craciun
Hello all! I'm uncertain if what I've observed (and describe below) is a bug, works as expected (but I've not found it mentioned in the documentation), or it's just a by-product of combining two advanced features that haven't been thoroughly tested together. So, to summarize: I'm trying to use t

Re: Unexpected behavior when combining `generated always` columns and update rules

2023-04-13 Thread Ciprian Craciun
On Thu, Apr 13, 2023 at 5:32 PM David G. Johnston wrote: > ALSO rules behave like before triggers, not after triggers. The original > command is appended to the end of the list of commands, not the start. As Tom observed, the documentation states that in case of update rules, the original query