pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedWhere is the qualification par in the Query Tree
2+ messages / 2 participants
[nested] [flat]
* Where is the qualification par in the Query Tree
@ 2020-04-21 12:49 Marc Rechté <marc4@rechte.fr>
2020-04-21 14:04 ` Re: Where is the qualification par in the Query Tree Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Rechté @ 2020-04-21 12:49 UTC (permalink / raw)
To: pgsql-docs
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 ?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Where is the qualification par in the Query Tree
2020-04-21 12:49 Where is the qualification par in the Query Tree Marc Rechté <marc4@rechte.fr>
@ 2020-04-21 14:04 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2020-04-21 14:04 UTC (permalink / raw)
To: Marc Rechté <marc4@rechte.fr>; +Cc: pgsql-docs
=?UTF-8?Q?Marc_Recht=c3=a9?= <marc4@rechte.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-04-21 14:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-04-21 12:49 Where is the qualification par in the Query Tree Marc Rechté <marc4@rechte.fr>
2020-04-21 14:04 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox