| From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
|---|---|
| To: | postgres sql list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | integer attribute 1672 != 1672 |
| Date: | 2001-11-12 14:47:09 |
| Message-ID: | 1005576429.31390.4.camel@entwicklung01.cenes.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-11-12 15:35:04 | Re: integer attribute 1672 != 1672 |
| Previous Message | Stephan Szabo | 2001-11-12 14:39:50 | Re: no cond returns diff res than cond or !cond |