On Sat, Jan 4, 2025 at 2:58 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Also, I've confirmed by looking at the plan tree that the implicit
> cast of c1 from integer to numeric is done in the targetlist of
> the Subquery Scan node. (I'm surprised that EXPLAIN VERBOSE hides
> that function call; it's not very helpful that it does so.)
Yeah, it seems that we tend to hide function calls that are implicit
casts. show_plan_tlist() calls deparse_expression() with showimplicit
set to false, and get_func_expr() does not display function calls of
COERCE_IMPLICIT_CAST in this case.
Thanks
Richard