Postgres Pro
Downloads
Home   >   mailing lists

Re: UNION makes strange duplicates - Mailing list pgsql-bugs

From Tom Lane
Subject Re: UNION makes strange duplicates
Date
Msg-id 14809.1117206187@sss.pgh.pa.us
Whole thread Raw
In response to UNION makes strange duplicates  (Tomasz Brzezina <biuro@sam.w3.pl>)
List pgsql-bugs
Tree view 
Tomasz Brzezina <biuro@sam.w3.pl> writes:
> document_id     vat_type_id     vat_type_value     document_netto_value
> 65615        1        0        0
> 65615        4        0.07        -12.5327
> 65615        5        0.22        -7.31148
> 65615        5        0.22        -7.31148

Perhaps document_item_value is float4, and there is some low-order-bit
difference in the sums?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #1682: subselect generates multiple rows
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1643: dbf2pg broken + quick fix