The following bug has been logged online: Bug reference: 2837 Logged by: canli Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: Linux ES 4 Description: i received ERROR: failed to build any 7-way joins Details:
When I execute a query: SELECT n1.numer AS wydany_nr, n2.numer AS zwrocony_nr FROM operacje o LEFT JOIN (wydane_numery wt1 JOIN boki_ numery bn1 USING(id_nr_w_bok) JOIN numery n1 USING(id_numeru )) ON(wt1.id_operacji = o.id_operacji AND wt1.wydanie_zwrot = 'W') LEFT JOIN (wydane_numery wt2 JOIN boki_numery bn2 USING(id_nr_w_bok) JOIN numery n2 USING(id_numeru )) ON(wt2.id_operacji = o.id_operacji AND wt2.wydanie_zwrot = 'Z') WHERE o.id_operacji = 349736 i received an error: failed to build any 7-way joins ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate