Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fACEYnm07700 for ; Mon, 12 Nov 2001 09:34:50 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD9501247.dip.t-dialin.net [217.80.18.71]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fACEYL203675 for ; Mon, 12 Nov 2001 15:34:21 +0100 Subject: integer attribute 1672 != 1672 From: Markus Bertheau To: postgres sql list Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.99.0 (Preview Release) Date: 12 Nov 2001 15:47:09 +0100 Message-Id: <1005576429.31390.4.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200111/154 X-Sequence-Number: 5538 Good day, cenes=> select version(); version --------------------------------------------------------------- PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2 (1 row) cenes=> \d partner_views Table "partner_views" Attribute | Type | Modifier ------------+-----------+---------- partner_id | integer | not null timestamp | timestamp | not null Indices: partner_id_partner_views_key, timestamp_partner_views_key cenes=> select count(partner_id), partner_id from partner_views group by partner_id order by partner_id; count | partner_id --------+------------ 21473 | 0 1 | 1672 116636 | 0 266 | 1670 17991 | 1672 1 | 0 79614 | 1672 3723 | 1677 39 | 1692 30150 | 1814 3853 | 1874 4951 | 1905 2 | 1948 28 | 2101 241 | 2129 (15 rows) how can this be? is it a known bug which is fixed in 7.1.3?