On 26 June 2014 10:01, David Rowley <dgrowle...@gmail.com> wrote: >> Did you comment on the transitive closure question? Should we add a >> test for that, whether or not it works yet? >> > > In my previous email. > > I could change the the following to use c.id in the targetlist and group by > clause, but I'm not really sure it's testing anything new or different. > > EXPLAIN (COSTS OFF) > SELECT a.id FROM a > LEFT JOIN (SELECT b.id,1 as dummy FROM b INNER JOIN c ON b.id = c.id GROUP > BY b.id) b ON a.id = b.id AND b.dummy = 1;
OK, agreed, no need to include. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers