> Is this the right way to do these checks? I'll try to look into it a
> bit more today, but does this cause problems when an UPDATE *doesn't*
> create leftovers?
I did some extra testing but couldn't find any problems. I looked at
INSERT policies when FOR PORTION OF exactly matches a row's bounds (so
the row is updated but there are no leftovers), and also INSERT
policies that include sublinks.
> We should update the documentation as well. I think it should point
> out the contrast between ACLs and RLS here.
Here is a v2 with a couple lines of documentation added.
Yours,
--
Paul ~{:-)
pj@illuminatedcomputing.com