How can I pushdown of functions used in targetlist with FDW ?
I know non-built-in functions can pushdown with WHERE clauses.
https://www.postgresql.org/docs/12/postgres-fdw.html#id-1.11.7.42.10
But I would like to pushdown function when use targetlist.
For example, I would like to change "Remote SQL: SELECT h FROM
public.hs" to "Remote SQL: SELECT avals(h) FROM public.hs" in bellow case.
postgres=# explain (verbose) SELECT avals(h) FROM tab_hstore;
QUERY PLAN
------------------------------------------------------------------------------
Foreign Scan on public.tab_hstore (cost=100.00..157.52 rows=1462
width=32)
Output: avals(h)
Remote SQL: SELECT h FROM public.hs
How to pushdown function in targetlist with FDW?
And if it can not pushdown, do you have a plan to add features?
Regards,
Shigeo Hirose
