Postgres Pro
Downloads
Home   >   mailing lists

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 CAPzqDmgxd-q7JgSg00hdyviuNVHpraGtpqs-7+RwaONvfmAK_Q@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 arelation in a given query
List pgsql-hackers
Tree view
Well for this given query it is possible. I haven't come across any such query yet.

Possibly because I am more concerned about the TPCDS and TPCH benchmarks, where it's less likely to occur.

On 13 October 2017 at 00:52, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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



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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] How does postgres store the join predicate for a relation in a given query
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] [POC] hash partitioning