Re: [HACKERS] How does postgres store the join predicate for arelation in a given query - Mailing list pgsql-hackers

From Gourav Kumar
Subject Re: [HACKERS] How does postgres store the join predicate for arelation in a given query
Date
Msg-id CAPzqDmgXvQ9qvQCzsD5kQnkYSBJy0Cu1T_SnrJu9rTpAmiy71Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] How does postgres store the join predicate for a relation in a given query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] How does postgres store the join predicate for a relation in a given query
List pgsql-hackers
A Join clause/predicate will only mention 2 relations. It can't have 3 or more relations.

On 12 October 2017 at 23:14, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Gourav Kumar <gourav1905@gmail.com> writes:
> My objective is to construct join graph from a given query.
> A join graph, has a node for each relation involved in a join, and an edge
> between two relations if they share a join predicate among them.

Hm, well, you could adapt the logic in have_relevant_joinclause() and
have_relevant_eclass_joinclause().  Or maybe you could just use them
as-is ... depends on what you have in mind to do with join clauses
that mention 3 or more relations.

                        regards, tom lane



--
Thanks,
Gourav Kumar
Computer Science and Automation
Indian Institute of Science

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Parallel Append implementation
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] postgres_fdw super user checks