pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Bertheau <twanger@bluetwanger.de>
To: postgres sql list <pgsql-sql@postgresql.org>
Subject: integer attribute 1672 != 1672
Date: 12 Nov 2001 15:47:09 +0100
Message-ID: <1005576429.31390.4.camel@entwicklung01.cenes.de> (raw)

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?





view thread (6+ messages)  latest in thread

Message-ID: <1005576429.31390.4.camel@entwicklung01.cenes.de>
Permalink:  ../1005576429.31390.4.camel@entwicklung01.cenes.de/
Also on:    postgresql.org/message-id/1005576429.31390.4.camel@entwicklung01.cenes.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: twanger@bluetwanger.de
  Subject: Re: integer attribute 1672 != 1672
  In-Reply-To: <1005576429.31390.4.camel@entwicklung01.cenes.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox