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

BUG #1609: Bug in interval datatype for 64 Bit timestamps

From: "Oliver Siegmar" <oliver(at)siegmar(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date: 2005-04-20 15:04:32
Message-ID: 20050420150432.0B2B2F0E4A@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1609
Logged by:          Oliver Siegmar
Email address:      oliver(at)siegmar(dot)net
PostgreSQL version: 8.0.2
Operating system:   Linux
Description:        Bug in interval datatype for 64 Bit timestamps
Details: 

Postgres compiled with --enable-integer-datetimes has a bug in interval
datatype representation -

select '10.10 secs ago'::interval;

     interval
-------------------
 @ 10.-10 secs ago
(1 row)


Without --enable-integer-datetimes -

     interval
------------------
 @ 10.10 secs ago
(1 row)


Please CC me, because I'm not on the list.


Oliver

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-04-20 15:10:13
Subject: Re: BUG #1608: integer negative limit in plpgsql function arguments
Previous:From: PaulDate: 2005-04-20 14:46:51
Subject: BUG #1608: integer negative limit in plpgsql function arguments

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