On Fri, Oct 21, 2022 at 11:38 PM Kostya M <kostya27(at)gmail(dot)com> wrote:
>
> Ok, thanks.
> For me even this scope resolution looks quite strange and unexpected.
>
See also the FAQ entry for this question:
https://wiki.postgresql.org/wiki/FAQ#Why_doesn.27t_PostgreSQL_report_a_column_not_found_error_when_using_the_wrong_name_in_a_subquery.3F