Gerzson Szinyei (gerzson(at)elender(dot)hu) reports a bug with a severity of 1
The lower the number the more severe it is.
Except all eliminates what it shouldnt
"except all" eliminates records which had 2 instances in the original table, and one instance in the table to be eliminated. One instance should have showed up in the result.
When I filter the original table with "where field=nnnn", (the id of the problem record), and do the "except all" for only the records in questtion, the result is one instance as it should be.
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: Tom Stowell||Date: 2001-08-14 05:55:31|
|Subject: -ltermcap needed for psql client build on OpenBSD 2.9|
|Previous:||From: Szinyei Gerzson||Date: 2001-08-14 05:22:03|
|Subject: Except all bug in PostgreSQL 7.1*|