Except all eliminates what it shouldnt

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Except all eliminates what it shouldnt
Дата
Msg-id 200108140549.f7E5nqT85363@hub.org
обсуждение исходный текст
Ответы Re: Except all eliminates what it shouldnt  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: assorted documentation errors
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: triggers