BUG #5672: Can't input julian days BC

From: "Benjamin Gigot" <therealvaldor(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5672: Can't input julian days BC
Date: 2010-09-22 07:17:01
Message-ID: 201009220717.o8M7H10X076516@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5672
Logged by: Benjamin Gigot
Email address: therealvaldor(at)hotmail(dot)com
PostgreSQL version: 8.4.4
Operating system: Ubuntu
Description: Can't input julian days BC
Details:

After trying to enter Confucius birthday (28th September 551BC) I had the
following error :

Query failed: ERROR: date/time field value out of range: "J1520447"

I then used a psql to try to enter different dates in the Julian days
format.

The date down to 0001-01-01 is working :

test=> INSERT INTO datetest (date) VALUES ('J1721426');
INSERT 0 1

But then under that it's not working anymore :

test=> INSERT INTO datetest (date) VALUES ('J1721425');
ERROR: date/time field value out of range: "J1721425"
LINE 1: INSERT INTO datetest (date) VALUES ('J1721425');

Documentation specify that dates can go down to J0, that is 4713BC.

Am I missing something ?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-09-22 08:25:33 Re: BUG #5661: The character encoding in logfile is confusing.
Previous Message Jeff Davis 2010-09-22 07:05:23 UNLISTEN bug