On Thursday, March 16, 2023, 德哥 <
digoal@126.com> wrote:
In this case, `where a.ts < exclude. ts` and `order by ts desc` are used. The ts of the tuple inserted first is the largest. So why throw an error? Throwing an error here is obviously not logically correct.
You’d get a duplicate value violation instead. As it stands, which error you get is somewhat non-deterministic, but you will get one.
David J.