It's worth mentioning that Postgres no longer follows that rule. I just looked it up to see what you meant and after version 10 it does not apply