Hi, I have a query that throws "ERROR: failed to build any 4-way joins SQL state: XX000".
Here's an (arguably) simplified version of it that doesn't require any of my table:
select 1 from (select 1 as col) t1 cross join (select 1 as col) t2 left outer join (select 1 as col) t3 on t1.col = t3.col and t2.col = t3.col and 1 = t3.col left outer join (select 1 as col) t4 on t3.col = t4.col I am on PostgreSQL 8.2 beta1 under Windows XP Service Pack 2. Thanks, Jean-Pierre Pelletier e-djuster ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster