Skip site navigation (1) Skip section navigation (2)

Re: Bug or Feature ?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Norbert Meissner <norbert(dot)meissner(at)str(dot)daimler-benz(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgreSQL(dot)org>
Subject: Re: Bug or Feature ?
Date: 2000-05-26 16:40:42
Message-ID: Pine.LNX.3.96.1000526183525.30646B-100000@ara.zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 26 May 2000, Norbert Meissner wrote:

> Hi all,
> 
> i found a strange behaviour in Postgresql 7.0 on FreeBSD 4.0
> 
> $ createdb foo
> $psql foo
> foo=# create table number (a_number int);
> foo=# insert into number values(1500000000);
> foo=# insert into number values(1600000000);
> select avg(a_number) from number;
>     avg
> ------------
>  -597483648
> 


test=# select avg(a_number::int8) from number;
    avg
------------
 1550000000
(1 row)

 The parser select function from column type. You use 'int' --- the parser
use avg(int4)....
						Karel



In response to

Responses

pgsql-admin by date

Next:From: Karel ZakDate: 2000-05-26 17:47:52
Subject: Re: Bug or Feature ?
Previous:From: Norbert MeissnerDate: 2000-05-26 16:39:05
Subject: Bug or Feature ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group