Simple examples of left vs inner join lateral in PostgreSQL

pg-lateral-join.sql

--  i | i
-- ---+---
--  1 |
--  2 | 2
-- (2 rows)
select *
from (
  values (1), (2)
) x(i)
left join lateral (
  select *
  from (
    values (2), (3)
  ) y(i)
  where x.i = y.i
) y(i) on true
;

--  i | i
-- ---+---
--  2 | 2
-- (1 row)
select *
from (
  values (1), (2)
) x(i)
inner join lateral (
  select *
  from (
    values (2), (3)
  ) y(i)
  where x.i = y.i
) y(i) on true
;