Skip site navigation (1) Skip section navigation (2)

Re: BUG #1762: Integer multiplication error

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Milos Babic <milos(dot)babic(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1762: Integer multiplication error
Date: 2005-07-09 13:29:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Sat, Jul 09, 2005 at 10:25:16AM +0100, Milos Babic wrote:
> When I try from psql to select:
> select 1024*1024*4500;
> it responses with:
> error integer out of range
> is it known bug or what is going on?

From "Numeric Constants" in the "SQL Syntax" chapter of the

  A numeric constant that contains neither a decimal point nor an
  exponent is initially presumed to be type integer if its value
  fits in type integer (32 bits); otherwise it is presumed to be
  type bigint if its value fits in type bigint (64 bits); otherwise
  it is taken to be type numeric.

All three constants in the expression meet the criteria for being
an integer, so the expression's result will be an integer as well.
Since the result (4718592000) would overflow 32 bits, PostgreSQL
raises an error (versions prior to 8.0 gave an incorrect result,
as you discovered).

> it also happens when I try to insert 1024*1024*4500 into int8 field in
> database!

The expression has to be evaluated before it can be inserted into
a table, and since it's an integer expression you get the overflow
error.  Cast one of the operands to bigint if you want the result
to be a bigint.

Michael Fuhr

In response to

pgsql-bugs by date

Next:From: Denis VlasenkoDate: 2005-07-10 10:05:10
Subject: Re: BUG #1756: PQexec eats huge amounts of memory
Previous:From: Michael FuhrDate: 2005-07-09 12:00:24
Subject: Re: Cast

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group