Home > mailing lists

Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
Date	March 22, 2022 15:42:23
Msg-id	CAKFQuwYaUor6xD0QEro0OLqxhv4gc7xmAWqfqhZF9zhKEny-jw@mail.gmail.com Whole thread Raw
In response to	Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause (Torsten Förtsch <tfoertsch123@gmail.com>)
List	pgsql-general

Tree view

On Tuesday, March 22, 2022, Torsten Förtsch <tfoertsch123@gmail.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.

pgsql-general by date:

From: "Shukla, Pranjal"
Date: 22 March 2022, 14:32:47
Subject: PG12: Any drawback of increasing wal_keep_segments

From: PALAYRET Jacques
Date: 22 March 2022, 15:48:21
Subject: Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause

Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause - Mailing list pgsql-general

Previous

Next