From 9ed36c2eed34b23560abe3cdf373c720b24d3b30 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Thu, 19 Nov 2015 15:10:46 -0500
Subject: - Fixed the ``.python_type`` attribute of
 :class:`.postgresql.INTERVAL` to return ``datetime.timedelta`` in the same
 way as that of :obj:`.types.Interval.python_type`, rather than raising
 ``NotImplementedError``. fixes #3571

(cherry picked from commit 29d6f6e19b014bb5ce79032bd8803e32b4da0e5e)
---
 lib/sqlalchemy/dialects/postgresql/base.py | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'lib/sqlalchemy/dialects/postgresql')

diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py
index ef870a177..8de5bede7 100644
--- a/lib/sqlalchemy/dialects/postgresql/base.py
+++ b/lib/sqlalchemy/dialects/postgresql/base.py
@@ -603,6 +603,8 @@ a new version.
 """
 from collections import defaultdict
 import re
+import datetime as dt
+
 
 from ... import sql, schema, exc, util
 from ...engine import default, reflection
@@ -709,6 +711,10 @@ class INTERVAL(sqltypes.TypeEngine):
     def _type_affinity(self):
         return sqltypes.Interval
 
+    @property
+    def python_type(self):
+        return dt.timedelta
+
 PGInterval = INTERVAL
 
 
-- 
cgit v1.2.1