Re: How does postgres store the join predicate for a relation in a given query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gourav Kumar <gourav1905(at)gmail(dot)com>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How does postgres store the join predicate for a relation in a given query
Date: 2017-10-12 19:22:16
Message-ID: 28956.1507836136@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gourav Kumar <gourav1905(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gourav Kumar 2017-10-12 19:30:30 Re: How does postgres store the join predicate for a relation in a given query
Previous Message Robert Haas 2017-10-12 19:18:37 Re: Optimise default partition scanning while adding new partition