Re: Unnecessary lateral dependencies implied by PHVs

I thought lateral join imply nestloop join,  am I missing something?  Here is my simple

testing. 

postgres=# explain (costs off) select * from r1 join lateral (select r1.a from r2) on true;
         QUERY PLAN
----------------------------
 Nested Loop
   ->  Seq Scan on r1
   ->  Materialize
         ->  Seq Scan on r2
(4 rows)

Time: 0.349 ms
postgres=# set enable_nestloop to off;
SET
Time: 0.123 ms

postgres=# explain (costs off) select * from r1 join lateral (select r1.a from r2) on true;
         QUERY PLAN
----------------------------
 Nested Loop
   ->  Seq Scan on r1
   ->  Materialize
         ->  Seq Scan on r2
(4 rows)