Except all eliminates what it shouldnt - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Except all eliminates what it shouldnt
Date
Msg-id 200108140549.f7E5nqT85363@hub.org
Whole thread Raw
Responses Re: Except all eliminates what it shouldnt  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Gerzson Szinyei (gerzson@elender.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
onlythe 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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: assorted documentation errors
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: triggers