On Sat, Oct 10, 2020 at 9:13 AM Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)com>
wrote:
This has nothing to do with pgAdmin, or any other client interface.
In other words, a wrong query returns a valid result. This happens because
> v1 is a column from test1, (select vx from test2) will return an error as
> expected.
>
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
I am pondering trying to get the FAQ entry incorporated into the actual
documentation.
David J.