| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: In postgres_fdw, allow CASE expressions to be pushed to the remo |
| Date: | 2021-07-30 17:39:59 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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/[email protected]
Branch
------
master
Modified Files
--------------
contrib/postgres_fdw/deparse.c | 212 +++++++++++++++++++++++--
contrib/postgres_fdw/expected/postgres_fdw.out | 90 +++++++++++
contrib/postgres_fdw/sql/postgres_fdw.sql | 29 ++++
3 files changed, 315 insertions(+), 16 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2021-07-30 18:03:32 | Re: pgsql: Re-enable TAP tests of pg_receivewal for ZLIB on Windows |
| Previous Message | Etsuro Fujita | 2021-07-30 13:00:49 | Re: pgsql: postgres_fdw: Fix handling of pending asynchronous requests. |