Thanks to all for the education! The bug was in my understanding (and that bloggers)... and the diverse SQL implementations are doing what they're meant to. I'll read up more.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных