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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
