> 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

Thanx for your reply.
Are you implying this is normal behaviour? Other drivers like Interclient
with Firebird or JConnect with Sybase return INTEGER though and the numbers
I've been testing with are very small.

Haris.