Re: Support for dates before 4713 BC

"Watzinger, Alexander" writes: > Any chance to add support for dates before 4713 BC? We really would > appreciate that. I'm a little skeptical of the value of applying the Gregorian calendar before 1582 AD, let alone thousands of years before the Romans invented anything looking even vaguely lik

Re: Support for dates before 4713 BC

On 2022-08-20 14:05:42 +, Watzinger, Alexander wrote: > I'm working on the open source project OpenAtlas (https://openatlas.eu) which > is used to enter historical and archeological data. > Although we really appreciate the wonderful PostgreSQL software, the > limitation > of not being able to

Re: Support for dates before 4713 BC

On 8/20/22 07:05, Watzinger, Alexander wrote: Hi all, I'm working on the open source project OpenAtlas (https://openatlas.eu ) which is used to enter historical and archeological data. Although we really appreciate the wonderful PostgreSQL software, the limitation of not

Re: With Recursive / Recursive View question

On 2022-08-20 17:42:27 -0500, Perry Smith wrote: > This select is almost instant: > > > WITH RECURSIVE pathname(id, parent_id, basename) AS ( > SELECT child.id, child.parent_id, child.basename > FROM dirents child > WHERE basename = '10732.emlx' > UNION ALL >

Support for dates before 4713 BC

Hi all, I'm working on the open source project OpenAtlas (https://openatlas.eu) which is used to enter historical and archeological data. Although we really appreciate the wonderful PostgreSQL software, the limitation of not being able to use dates before 4713 BC is problematic in regard to arc