integer attribute 1672 != 1672 - Mailing list pgsql-sql

From Markus Bertheau
Subject integer attribute 1672 != 1672
Date
Msg-id 1005576429.31390.4.camel@entwicklung01.cenes.de
Whole thread Raw
Responses Re: integer attribute 1672 != 1672
Re: integer attribute 1672 != 1672
List pgsql-sql
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 nulltimestamp  | 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 |       1672116636 |          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?




pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: no cond returns diff res than cond or !cond
Next
From: Stephan Szabo
Date:
Subject: Re: no cond returns diff res than cond or !cond