"Raymond O'Donnell" <rod@xxxxxx> writes: > I've just run into the above error (with the additional message "SQL > state XX000"). > Funny thing is, when I change the join (between the views) either to an > INNER JOIN or a RIGHT JOIN, the query works - it only goes belly-up when > I try a LEFT JOIN. This sounds like a known bug in 8.2.x --- it's fixed for 8.2.4. If you can still reproduce it with 8.2.4, please provide the test case. regards, tom lane
