Re: [BUGS] Postgres storing time in strange manner - Mailing list pgsql-novice

From Ron Johnson
Subject Re: [BUGS] Postgres storing time in strange manner
Date
Msg-id 1032224202.25231.11.camel@haggis
Whole thread Raw
In response to Re: [BUGS] Postgres storing time in strange manner  (Rod Taylor <rbt@rbt.ca>)
Responses Re: [BUGS] Postgres storing time in strange manner
List pgsql-novice
On Sun, 2002-09-15 at 09:51, Rod Taylor wrote:
> On Sun, 2002-09-15 at 10:32, Tom Lane wrote:
> > > On Sunday 15 September 2002 10:11 am, Rod Taylor wrote:
> > >> On Sun, 2002-09-15 at 03:57, Casey Allen Shobe wrote:
> > >>> I don't have a clue why it's doing this - has anyone else seen this sort
> > >>> of behavior, or know why it might be doing it?  It shows times wrong, for
> > >>> instance, it shows 00:04:60 where it should show 00:05:00.  See below:
> > >>
> > >> There are actually 61 seconds in some minutes.  In order to accommodate
> > >> leap seconds, PostgreSQL allows this to happen -- similarly to how it
> > >> will also allow 366 days in some years.
> >
> > True but irrelevant -- PG does not do accounting for leap seconds.
>
> For some reason I thought it did accommodate it when I was still using
> 7.1.
>
> Ahh well, if the bug is fixed, then it's all good.

In a subsequent post, Tom Lane said that 7.2.2 fixed the problem,
but a reply post from the original poster says that he is, in fact,
using 7.2.2...

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



pgsql-novice by date:

Previous
From: Terry Yapt
Date:
Subject: Re: psql and readline library: cursor keys
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner