Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [HACKERS] How does postgres store the join predicate for a relation in a given query
Date
Msg-id 30260.1507826316@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] How does postgres store the join predicate for arelation in a given query  (Gourav Kumar <gourav1905@gmail.com>)
Responses Re: [HACKERS] How does postgres store the join predicate for arelation in a given query
List pgsql-hackers
Tree view 
Gourav Kumar <gourav1905@gmail.com> writes:
> I have the RelOptInfo data structure for the relations which are to be
> joined but when I check their joininfo, it is empty.

You aren't telling us anything much about the case you're studying,
but if the join clauses have the form of equality comparisons, they
likely got converted into EquivalenceClass data structures instead.
These days the joininfo lists only contain "unstructured" join
conditions.
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Gourav Kumar
Date:
Subject: Re: [HACKERS] How does postgres store the join predicate for arelation in a given query
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Add port/strnlen support to libpq and ecpg Makefiles.