Re: self join revisited
От
Tom Lane
Тема
Re: self join revisited
Дата
Msg-id
7884.1238606350@sss.pgh.pa.us
Ответ на
self join revisited (Rikard Pavelic)
Список
Дерево обсуждения
self join revisited Rikard Pavelic <rikard.pavelic@zg.htnet.hr>
Re: self join revisited Tom Lane <tgl@sss.pgh.pa.us>
Re: self join revisited Rikard Pavelic <rikard.pavelic@zg.htnet.hr>
Re: self join revisited Robert Haas <robertmhaas@gmail.com>
Re: self join revisited Matthew Wakeling <matthew@flymine.org>
Rikard Pavelic writes: > It would be great if Postgres could rewrite this query AFAICS those queries are not going to produce the same results, so Postgres would be 100% incorrect to rewrite it like that for you. (If they do produce the same results, it would depend on a bunch of assumptions you have not stated.) regards, tom lane
В списке pgsql-performance по дате отправления
