On Tue, Jan 09, 2007 at 10:10:46 -0600,
Jeanna Geier <jgeier@apt-cafm.com> wrote:
>
> If I cast the entire operation to an INT:
> (a.area * su.units_per_sqfoot::integer)::integer AS area_sq
> or by
> (a.area * su.units_per_sqfoot)::integer AS area_sq,
> I'm getting an 'ERROR: integer out of range' error returned when I run my
> SELECT statement:
This suggests that the values are too large to be represented in int4. Can
you switch to using int8?