summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChris Withers <chris@simplistix.co.uk>2013-06-26 07:29:48 +0100
committerChris Withers <chris@simplistix.co.uk>2013-06-26 07:29:48 +0100
commitfb469dfb240ef62ee05d58f843f4923c635a6ad2 (patch)
tree2a59549aac8744e208cb7c9459f22df202be3253
parent110877cf14e10c2d16ec26ddabb0ecc6a5ef9af1 (diff)
downloadsqlalchemy-pr/12.tar.gz
Tidy range types docs and add warning about the return type support offered by different versions of different DBAPI libraries.pr/12
-rw-r--r--doc/build/dialects/postgresql.rst20
1 files changed, 18 insertions, 2 deletions
diff --git a/doc/build/dialects/postgresql.rst b/doc/build/dialects/postgresql.rst
index d401eef5b..3c151483f 100644
--- a/doc/build/dialects/postgresql.rst
+++ b/doc/build/dialects/postgresql.rst
@@ -82,8 +82,11 @@ construction arguments, are as follows:
:members: __init__
:show-inheritance:
-.. autoclass:: sqlalchemy.dialects.postgresql.ranges.RangeOperators
- :members:
+Range Types
+~~~~~~~~~~~
+
+The new range column types founds in PostgreSQL 9.2 onwards are
+catered for by the following types:
.. autoclass:: INT4RANGE
:show-inheritance:
@@ -103,6 +106,19 @@ construction arguments, are as follows:
.. autoclass:: TSTZRANGE
:show-inheritance:
+The types above get most of their functionality from the following
+mixin:
+
+.. autoclass:: sqlalchemy.dialects.postgresql.ranges.RangeOperators
+ :members:
+
+.. warning::
+
+ The range type DDL support should work with any Postgres DBAPI
+ driver, however the data types returned may vary. If you are using
+ ``psycopg2``, it's recommended to upgrade to version 2.5 or later
+ before using these column types.
+
PostgreSQL Constraint Types
---------------------------