BC date getting misinterpreted?

From: Joe Abbate <jma(at)freedomcircle(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: BC date getting misinterpreted?
Date: 2018-03-26 23:11:55
Message-ID: 901cb864-1f80-4fd2-43cc-82528c149b3d@freedomcircle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

The test case is fairly simple:

curs.execute("SELECT '044-03-15 BC'::date")
rows = curs.fetchall()

This results in:

ValueError: year -43 is out of range

[This is Python 3.6, in 2.7, the value is missing]

This was working since last October, but the error started happening
around the Ides of March (my actual dates are different, but I changed
the example to fit :-)

Tested against 9.3 thru 10.

Joe

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2018-03-26 23:15:14 Re: BC date getting misinterpreted?
Previous Message Mike Bayer 2018-02-27 19:44:24 Re: About the psycopg2 name