I don't think they're doing it to match a DB vendor consensus I suspect they're doing it because postgres specifically does. I'm not aware of any official expr

I don't think they're doing it to match a DB vendor consensus I suspect they're doing it because postgres specifically does. I'm not aware of any official expression of this, but for the past several years at least sqlite seems to be treating what postgres does as a sort of spec, and aligning with its behavior unless they have a specific reason not to. Which is great imo.