On Thu, 17 Oct 2024 at 01:26, Richards, Nina <nina.richa...@oeaw.ac.at> 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
