Re: [HACKERS] How does postgres store the join predicate for arelation in a given query

Поиск
Список
Период
Сортировка
От Gourav Kumar
Тема Re: [HACKERS] How does postgres store the join predicate for arelation in a given query
Дата
Msg-id CAPzqDmgxd-q7JgSg00hdyviuNVHpraGtpqs-7+RwaONvfmAK_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] How does postgres store the join predicate for a relation in a given query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] How does postgres store the join predicate for arelation in a given query  (Gourav Kumar <gourav1905@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] How does postgres store the join predicate for a relation in a given query
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] [POC] hash partitioning