Re: [HACKERS] Dates BC. - Mailing list pgsql-patches

From Karel Zak
Subject Re: [HACKERS] Dates BC.
Date
Msg-id 20040330071914.GA17619@zf.jcu.cz
Whole thread Raw
In response to Re: [HACKERS] Dates BC.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
On Mon, Mar 29, 2004 at 03:37:07PM -0500, Bruce Momjian wrote:
> Karel Zak wrote:
> > On Fri, Dec 19, 2003 at 01:12:08AM -0800, Dann Corbit wrote:
> > > There is no zero calendar year.  The first year of Anno Domini is 1.  It's ordinal, not cardinal.
> >
> >  I agree. But  the follow quoted  code is  not use in  date_part() there
> >  Kurt  found bug. It's  used  in to_timestamp()  _only_,  and it  works,
> >  because tm2timestamp() and date2j() work with zero year.
>
> I have also add a doc mention to my patch that mentions that there is no
> 0 AD, and therefore subtraction of BC years from AD years must be done
> with caution.

 The patch seems good for me. Thanks.

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Dates BC.
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml