Re: Bug fix for missing years in make_date() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug fix for missing years in make_date()
Date
Msg-id 20648.1427821107@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug fix for missing years in make_date()  (David Fetter <david@fetter.org>)
Responses Re: Bug fix for missing years in make_date()
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> On Tue, Mar 31, 2015 at 10:34:45AM -0400, Adam Brightwell wrote:
>> Previously, zero was rejected, what does it do now? I'm sure it represents
>> 0 AD/CE, however, is that important enough to note given that it was not
>> allowed previously?

> Now, it's supposed to take 0 as 1 BCE, -1 as 2 BCE, etc.  There should
> probably be tests for that.

Surely that is *not* what we want?  I'd expect any user-facing date
function to reject zero and take -1 as 1 BC, etc.  The behavior you
describe is an internal convention, not something we want to expose
to users.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Jacobo Vazquez
Date:
Subject: Fwd: SSPI authentication ASC_REQ_REPLAY_DETECT flag
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: a fast bloat measurement tool (was Re: Measuring relation free space)