From e310a8e423d9a4eeb511b7b84dbeccc90c234a1f Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 16 Feb 2016 10:05:58 -0500 Subject: [PATCH] - use same colname as the alias we give to the PG function here, fixes #3652 --- lib/sqlalchemy/sql/functions.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py index 756ad7e7e9..9dfcadf19d 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 -- 2.47.2