Re: Where is the qualification par in the Query Tree

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Rechté <marc4(at)rechte(dot)fr>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Where is the qualification par in the Query Tree
Date: 2020-04-21 14:04:52
Message-ID: 24516.1587477892@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

=?UTF-8?Q?Marc_Recht=c3=a9?= <marc4(at)rechte(dot)fr> writes:
> This refers to /doc/src/sgml/html/querytree.html, where one mentions a
> qualification part in the Query Tree. While reading the Query node
> (parsenode.h) and output from the log with debug_print_parse = on, I
> cannot see either this part. Is it gone in profit of join tree ?

As noted near the bottom of that documentation page:

It turns out to be convenient to store the top-level WHERE expression
as a qualification attached to the top-level join-tree item, too. So
really the join tree represents both the FROM and WHERE clauses of a
SELECT.

IOW, Query.jointree->quals.

regards, tom lane

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-04-21 15:31:09 Re: Backend Flowchart / Developer doc
Previous Message Marc Rechté 2020-04-21 12:49:16 Where is the qualification par in the Query Tree