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

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