Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
Cc: PALAYRET Jacques <jacques(dot)palayret(at)meteo(dot)fr>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
Date: 2022-03-22 12:42:23
Message-ID: CAKFQuwYaUor6xD0QEro0OLqxhv4gc7xmAWqfqhZF9zhKEny-jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, March 22, 2022, Torsten Förtsch <tfoertsch123(at)gmail(dot)com> wrote:
>
>
> Note the use of aliases, w and x. You are using a correlated subquery.
>

Yep. There is an FAQ entry if you’d like a bit more exposition.

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

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PALAYRET Jacques 2022-03-22 12:48:21 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
Previous Message Shukla, Pranjal 2022-03-22 11:32:47 PG12: Any drawback of increasing wal_keep_segments