"Jeanna Geier" <jgeier@xxxxxxxxxxxx> writes: > If I cast the entire operation to an INT: ... > I'm getting an 'ERROR: integer out of range' error returned when I run my > SELECT statement: Perhaps use floor() instead? regards, tom lane
"Jeanna Geier" <jgeier@xxxxxxxxxxxx> writes: > If I cast the entire operation to an INT: ... > I'm getting an 'ERROR: integer out of range' error returned when I run my > SELECT statement: Perhaps use floor() instead? regards, tom lane