Hmm, I thought this only really applied when you use functions which Postgres can’t reason about. Hence the LEAKPROOF keyword to help with this case.
Either way, I think it underscores that RLS shouldn’t be used for business logic. I’ll update the page to emphasize that more.