Except all eliminates what it shouldnt

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Except all eliminates what it shouldnt
Date: 2001-08-14 05:49:52
Message-ID: 200108140549.f7E5nqT85363@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Gerzson Szinyei (gerzson(at)elender(dot)hu) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Except all eliminates what it shouldnt

Long Description
"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.

Sample Code
http://www.webit.hu/~gerzson/pgexceptbugtest.tgz

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Stowell 2001-08-14 05:55:31 -ltermcap needed for psql client build on OpenBSD 2.9
Previous Message Szinyei Gerzson 2001-08-14 05:22:03 Except all bug in PostgreSQL 7.1*