From aec9bb16e62fa7a7541cb91691378244644d1487 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 (cherry picked from commit e310a8e423d9a4eeb511b7b84dbeccc90c234a1f) --- 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 50c1ef06e0..009ddbdfc8 100644 --- a/lib/sqlalchemy/sql/functions.py +++ b/lib/sqlalchemy/sql/functions.py @@ -168,7 +168,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') ) @@ -176,7 +176,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.3