Age function record data type misinterpreted

[alexhenman]

There seems to be some peculiarity with the way the result from calling the age function is being interpreted. The postgres documentation suggests that an interval is returned but it seems something unusual is happening in how this is getting parsed by psycopg.

Minimal steps for replicating are this:

connection = psycopg.connect(...)
cursor = connection.cursor()

# This returns datetime.timedelta(days=6) when it should be 6 months and 6 days
cursor.execute("SELECT age('2020-07-07 00:00:00'::timestamp, '2020-01-01 00:00:00'::timestamp);").fetchone()[0]

# Whereas just subtracting the timestamps results in the right output: datetime.timedelta(days=188)
cursor.execute("SELECT '2020-07-07 00:00:00'::timestamp - '2020-01-01 00:00:00'::timestamp;").fetchone()[0]

[dvarrazzo]

There seems to be a problem, yes, thank you for the report:

>>> conn.execute("select '6 months 6 days'::interval").fetchone()[0]
datetime.timedelta(days=6)

[alexhenman]

@dvarrazzo thanks for the very speedy fix!

[dvarrazzo]

No worries. Will release the fix in a couple of days: waiting to know if the workaround in #645 works to release it too.