Subject | Re: [Firebird-Java] SUM() |
---|---|

Author | Phil Shrimpton |

Post date | 2002-11-26T12:48:13Z |

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