Hello
there are maybe planner bug.
test case:
CREATE TABLE person (
id SERIAL PRIMARY KEY,
name VARCHAR(64)
) WITHOUT OIDS;
CREATE TABLE person_data (
id SERIAL PRIMARY KEY
) WITHOUT OIDS;
------------------------------------
SELECT name
FROM person
WHERE name IN (
SELECT name FROM person p
LEFT JOIN person_data ON p.id = person_data.id
)
postgres=# explain SELECT name
FROM person
WHERE name IN (
SELECT name FROM person p
LEFT JOIN person_data ON p.id = person_data.id);
ERROR: failed to build any 2-way joins
it works on 8.3
report by Vaclav Novotny
Regards
Pavel