Re: Extract epoch from Interval weird behavior - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Extract epoch from Interval weird behavior
Date
Msg-id 1352876.1645720057@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extract epoch from Interval weird behavior  (Joseph Koshakow <koshy44@gmail.com>)
List pgsql-hackers
Joseph Koshakow <koshy44@gmail.com> writes:
> I do want to briefly mention, if I'm understanding the history of
> EXTRACT correctly, that the previous behavior
> actually was to multiply by 365.25, not 365. However The commit that
> changed the return type from numeric [1]
> changed that behavior. Looking through the discussions [2], I don't
> see any mention of it, which makes me think
> it was a mistake.

Indeed ... Peter?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Brar Piening
Date:
Subject: Re: Add id's to various elements in protocol.sgml
Next
From: Mark Wong
Date:
Subject: Re: Time to drop plpython2?