]> git.ipfire.org Git - thirdparty/postgresql.git/commit
In postgres_fdw, allow CASE expressions to be pushed to the remote server.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 30 Jul 2021 17:39:48 +0000 (13:39 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 30 Jul 2021 17:39:48 +0000 (13:39 -0400)
commit5d44fff01eebfe0c7a118326605864e662a44f46
tree32a3521ca424393c75a7bb57a71f4b38135aefde
parent1d919de5eb3fffa7cc9479ed6d2915fb89794459
In postgres_fdw, allow CASE expressions to be pushed to the remote server.

This is simple enough except for the need to check whether CaseTestExpr
nodes have a collation that is not derived from a remote Var.  For that,
examine the CASE's "arg" expression and then pass that info down into the
recursive examination of the WHEN expressions.

Alexander Pyhalov, reviewed by Gilles Darold and myself

Discussion: https://postgr.es/m/fda09032e90d85d9b726a41e03f9097f@postgrespro.ru
contrib/postgres_fdw/deparse.c
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/sql/postgres_fdw.sql