"Mitch Vincent" <mitch@venux.net> writes:
> is_paid is never updated...
It's not possible that is_paid is never updated; that command *will*
replace the total, updated, and is_paid columns with *something*.
It may be that in the cases you've checked, it gets updated to the
same value it had before. That's why I want to see the test cases.
regards, tom lane