"Raymond O'Donnell" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
