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