On Tue, Jan 09, 2007 at 10:10:46 -0600, Jeanna Geier <jgeier@xxxxxxxxxxxx> 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?
