Re: BUG #2775: Error select

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mas Kus" <kusuma_ok(at)telkom(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2775: Error select
Date: 2006-11-24 21:47:20
Message-ID: 27016.1164404840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Mas Kus" <kusuma_ok(at)telkom(dot)net> writes:
> But, when I tried select :

> =>select 2148*1000000;
> ?column?
> ------------------
> -214623000

PG releases before 8.0 don't check for overflow in integer multiplication.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-11-24 21:58:03 Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Previous Message Alvaro Herrera 2006-11-24 21:45:32 Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table