int8-datatype: possible bug - Mailing list pgsql-general

From Jelle Ruttenberg
Subject int8-datatype: possible bug
Date
Msg-id 199905070718.JAA18209@mail.neroc.nl
Whole thread Raw
List pgsql-general
Hello all,

when I try to put a numeric 'timestamp' like 19980528112607 into an
int8-datatype I get the notice 'NOTICE:  Integer input '19980528112607'
is out of range; promoted to float' and the value is put in the database
as 9223091508918288644.
It doesn't matter if I change the value: it will allways be the magical
value 9223091508918288644.

When I use the float8-datatype it all goes well.

Is this a bug in PostgreSQL or has it something to do with
platform-specific limitations?

Thanks,

Jelle.

PostgreSQL: 6.4.2
Platform: SGI IRIX 6.2. IP22

--------------------------------------------------------------
                   NEROC Publishing Solutions

                      Jelle Ruttenberg

De Run 1131, 5503 LB Veldhoven    Phone  : +31-(0)40-2586641
P.O.Box 133, 5500 AC Veldhoven    Fax    : +31-(0)40-2541893
The Netherlands                   E-mail : ruttenberg@neroc.nl
--------------------------------------------------------------


pgsql-general by date:

Previous
From: "Natalya S. Makushina"
Date:
Subject: backend die with status 6
Next
From: Ferdi
Date:
Subject: PostGreSQL and LiveWire??