[BUGS] Except all bug in PostgreSQL 7.1*

2001-08-14 Thread Szinyei Gerzson
Hi, I have found a bug in PostgreSQL doing "except all". It removes some records which it shouldnt when I run except on large data sets. If I run the same except only on the records in question (using where...), it shows up in the result ok. I have put the data and small python code here: http:

[BUGS] Except all bug in PostgreSQL 7.1*

2001-08-14 Thread Szinyei Gerzson
Hi, I have found a bug in PostgreSQL doing "except all". Some records are removed from the result, even though they should stay. Except all removed records which were _not_ in the table that were excepted from the original table. I have put the data and small python code here: http://www.webit.