Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2775: Error select - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2775: Error select
Date
Msg-id 27016.1164404840@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2775: Error select  ("Mas Kus" <kusuma_ok@telkom.net>)
List pgsql-bugs
Tree view 
"Mas Kus" <kusuma_ok@telkom.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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Next
From: Tom Lane
Date:
Subject: Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table