On Tuesday 26 November 2002 13:46, you wrote:

Hi,

> SELECT SUM(some_column_name) FROM some_table
>
> where some_column_name is of type INTEGER
>
> returns a BIGDECIMAL number where, obviously, an INTEGER is expected.

Depends. It is more than possible that a sum of a number of integers results
in a number too big to fit in to an integer.

E.g.

2147483640 + 8

Phil
--
Linux 2.4.4-4GB
12:45pm up 3 days, 22:20, 1 user, load average: 0.25, 0.08, 0.03