Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange behavior - Mailing list pgsql-general

From David G. Johnston
Subject Re: Strange behavior
Date
Msg-id CAKFQuwazoKpJMe8Juhcp8KXueewzrpGLoF-ZpT8E32709n2KaQ@mail.gmail.com
Whole thread Raw
In response to Strange behavior  (Olivier Leprêtre <o.lepretre@gmail.com>)
Responses Re: Strange behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Sat, Oct 10, 2020 at 9:13 AM Olivier Leprêtre <o.lepretre@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.

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Strange behavior
Next
From: Tom Lane
Date:
Subject: Re: Strange behavior