diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-02-16 10:05:58 -0500 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-02-16 10:05:58 -0500 |
commit | e310a8e423d9a4eeb511b7b84dbeccc90c234a1f (patch) | |
tree | e7392a24fd5a902a59caf4167e4fdd01772b6ef6 | |
parent | 366f97b5617af0d15cfaf594ec5ef0408c70e873 (diff) | |
download | sqlalchemy-e310a8e423d9a4eeb511b7b84dbeccc90c234a1f.tar.gz |
- use same colname as the alias we give to the PG function
here, fixes #3652
-rw-r--r-- | lib/sqlalchemy/sql/functions.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py index 756ad7e7e..9dfcadf19 100644 --- a/lib/sqlalchemy/sql/functions.py +++ b/lib/sqlalchemy/sql/functions.py @@ -195,7 +195,7 @@ class FunctionElement(Executable, ColumnElement, FromClause): from sqlalchemy.sql import column - stmt = select([column('data')]).select_from( + stmt = select([column('data_view')]).select_from( func.unnest(Table.data).alias('data_view') ) @@ -203,7 +203,7 @@ class FunctionElement(Executable, ColumnElement, FromClause): .. sourcecode:: sql - SELECT data + SELECT data_view FROM unnest(sometable.data) AS data_view .. versionadded:: 0.9.8 The :meth:`.FunctionElement.alias` method |