Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps - Mailing list pgsql-bugs

From Oliver Siegmar
Subject Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date
Msg-id 200504201807.16908.oliver@siegmar.net
Whole thread Raw
In response to Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi Tom,

On Wednesday 20 April 2005 17:57, Tom Lane wrote:
> "Oliver Siegmar" <oliver@siegmar.net> writes:
> > select '10.10 secs ago'::interval;
> >
> >      interval
> > -------------------
> >  @ 10.-10 secs ago
> > (1 row)
>
> What datestyle are you using?

Non-ISO (Postgres in that case), but the handling for non-ISO is all the same
in interval.c ...


ISO works fine -

   interval
--------------
 -00:00:10.10
(1 row)



Oliver

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Next
From: Tom Lane
Date:
Subject: Re: BUG #1608: integer negative limit in plpgsql function arguments