On Sat, Oct 10, 2020 at 9:13 AM Olivier LeprĂȘtre <o.lepre...@gmail.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.