This behavior is required by the SQL standard. It's called an outer reference. regards, tom lane
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных