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 28956.1507836136@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:
> A Join clause/predicate will only mention 2 relations. It can't have 3 or
> more relations.

Really?  What of, say,
select ... from a,b,c where (a.x + b.y) = c.z;
        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: Robert Haas
Date:
Subject: Re: [HACKERS] Optimise default partition scanning while adding new partition
Next
From: Gourav Kumar
Date:
Subject: Re: [HACKERS] How does postgres store the join predicate for arelation in a given query