From: | Jelle Ruttenberg <ruttenberg(at)neroc(dot)nl> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | int8-datatype: possible bug |
Date: | 1999-05-07 07:24:50 |
Message-ID: | 199905070718.JAA18209@mail.neroc.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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(at)neroc(dot)nl
--------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | José Soares | 1999-05-07 12:26:38 | Re: [GENERAL] int8-datatype: possible bug |
Previous Message | Unprivileged user | 1999-05-05 16:43:10 | General Bug Report: "Create User TestUser IN GROUP group_name" does not add the user to the group. |
From | Date | Subject | |
---|---|---|---|
Next Message | Ferdi | 1999-05-07 08:19:46 | PostGreSQL and LiveWire?? |
Previous Message | Natalya S. Makushina | 1999-05-07 06:03:33 | backend die with status 6 |