Skip site navigation (1) Skip section navigation (2)

int8-datatype: possible bug

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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
--------------------------------------------------------------


Responses

pgsql-bugs by date

Next:From: José SoaresDate: 1999-05-07 12:26:38
Subject: Re: [GENERAL] int8-datatype: possible bug
Previous:From: Unprivileged userDate: 1999-05-05 16:43:10
Subject: General Bug Report: "Create User TestUser IN GROUP group_name" does not add the user to the group.

pgsql-general by date

Next:From: FerdiDate: 1999-05-07 08:19:46
Subject: PostGreSQL and LiveWire??
Previous:From: Natalya S. MakushinaDate: 1999-05-07 06:03:33
Subject: backend die with status 6

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group