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

From Mas Kus
Subject BUG #2775: Error select
Date
Msg-id 200611220840.kAM8ergP071418@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2775: Error select
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2775
Logged by:          Mas Kus
Email address:      kusuma_ok@telkom.net
PostgreSQL version: 7.4.1-2
Operating system:   Mandrake 10.0
Description:        Error select
Details:

Hello...
I'm using Mandrake 10.0 full version as my OS. And use it for my web server.
I've installed the PostgreSQL to my server. The connection to the database
is good. I try to select by :

=>select 2147*1000000;
  ?column?
--------------
 2147000000

But, when I tried select :

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

Or When I try to multiply with the number than result more than 2147000000,
the result is minus or wrong.

Can you help me why ?

Thank you.

pgsql-bugs by date:

Previous
From: Mikko Tiihonen
Date:
Subject: Re: BUG #2768: dates before year 1600 in timestamptz column
Next
From: "Mas Kus"
Date:
Subject: BUG #2774: Error select