On Tue, Jan 09, 2007 at 10:10:46 -0600, Jeanna Geier <[EMAIL PROTECTED]> 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? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
