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: (view raw or whole 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

No file was uploaded with this report


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-2015 The PostgreSQL Global Development Group