From 915c04f091f13dbbc0fde833e612dc90b70103ce Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 2 Jan 2020 14:02:46 -0500 Subject: [PATCH] Fix typmod exposed for scalar function in FROM, too. On further reflection about commit 4d02eb017, it occurs to me that expandRTE() had better agree with what addRangeTableEntryForFunction() is doing. So teach that about functions possibly having typmods, too. --- src/backend/parser/parse_relation.c | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/backend/parser/parse_relation.c b/src/backend/parser/parse_relation.c index 2e0c278f35..ceed0ceb48 100644 --- a/src/backend/parser/parse_relation.c +++ b/src/backend/parser/parse_relation.c @@ -2616,7 +2616,8 @@ expandRTE(RangeTblEntry *rte, int rtindex, int sublevels_up, Var *varnode; varnode = makeVar(rtindex, atts_done + 1, - funcrettype, -1, + funcrettype, + exprTypmod(rtfunc->funcexpr), exprCollation(rtfunc->funcexpr), sublevels_up); varnode->location = location; -- 2.39.5