| 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: | Whole Thread | Raw Message | 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
| 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 |