Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group