FAQ

[PostgreSQL 6.5.0 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1]
test1=> select count(*), max("ID"), min("ID"), avg("ID") from
"ItemsBars";
count| max| min| avg
------+-------+-----+----
677719|3075717|61854|-251
(1 row)
Overflow, perhaps?
Of course. These are integer fields? I've been considering changing
Yes, the fields are int4
all accumulators (and results) for integer aggregate functions to
float8, but have not done so yet. I was sort of waiting for a v7.0
release, but am not sure why...
Float8 accumulator seems to be a good solution if AVG is limited to
int/float types. I wonder if it could produce system dependency in AVG due
to rounding errors. Some broader solution should be considered though if you
want AVG to work on numeric/decimal as well.

Gene Sokolov.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 16 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJun 16, '99 at 6:42a
activeJun 17, '99 at 10:47a
posts16
users7
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase