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

From: Oliver Siegmar <oliver(at)siegmar(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date: 2005-04-20 16:07:16
Message-ID: 200504201807.16908.oliver@siegmar.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Tom,

On Wednesday 20 April 2005 17:57, Tom Lane wrote:
> "Oliver Siegmar" <oliver(at)siegmar(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-04-20 16:10:45 Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Previous Message Tom Lane 2005-04-20 15:57:37 Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps