Re: [BUGS] UNION makes strange duplicates

2005-05-27 Thread Tom Lane
Tomasz Brzezina <[EMAIL PROTECTED]> 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

[BUGS] UNION makes strange duplicates

2005-05-27 Thread Tomasz Brzezina
-- $psql -V psql (PostgreSQL) 7.4.7 contains support for command-line editing -- I have table with two _id (document_id and document_store_id). And I have a view: SELECT document_items.document_store_id AS document_id, document_items.vat_type_id, vat_type_value, sum(d