public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Rowley <[email protected]>
To: Richards, Nina <[email protected]>
Cc: Watzinger, Alexander <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Support for dates before 4713 BC
Date: Thu, 17 Oct 2024 13:17:01 +1300
Message-ID: <CAApHDvomL7e49Y0ZyCu4ZrSq-mF7bcnq6cz+8_BwvNM4bL+Ruw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Thu, 17 Oct 2024 at 01:26, Richards, Nina <[email protected]> wrote:
> Even though we know there was no calendar at that time, it would make our work much easier if we could use data before 4713 BC in the same way. Especially for statistical analyses and scientific dating methods (14C, dendrochronology), this would be a great benefit for us as well as the users of OpenAtlas.
>
>
> Are there, by any chance, news about this issue? Or are you aware of any suitable workarounds on the database level in the meantime?
It's by no means a trivial thing to do, but it is possible to
implement new types in PostgreSQL [1]. If you invented your own type,
you could significantly widen the upper and lower bounds when compared
with the standard date type.
David
[1] https://www.postgresql.org/docs/current/sql-createtype.html
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Support for dates before 4713 BC
In-Reply-To: <CAApHDvomL7e49Y0ZyCu4ZrSq-mF7bcnq6cz+8_BwvNM4bL+Ruw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox