> Oh, my mistake, I forgot that the WHERE clause would filter out NULLs. > Try > SELECT * FROM t1 LEFT JOIN t2 ON (x = y) WHERE y <> 2 OR y IS NULL; x y 1 1 3 NULL 4 4 Andreas
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных