Re: BUG #1927: incorrect timestamp returned

Kouber Saparev wrote:
> >>
> >>select timestamp '2005-09-23 23:59:59.9999999'
> >>
> >>I get the following result (note the value of the seconds):
> >>
> >>2005-09-23 23:59:60.00
> >
> >
> > It's the leap second.
> >
> >
>
> It is not a leap second. Leap seconds are always either on the 30th of
> June or on the 31th of December.
>
> Here there is a list of all the leap seconds so far:
> http://en.wikipedia.org/wiki/Leap_second
>
> And, in fact, the wrong result is the same for each date, regardless of
> the year, month or day.

Right. We allow leap seconds for any date/time. Are you saying we
should only allow them for certain dates/times?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073