Re: [PATCH][postgres_fdw] Add push down of CASE WHEN clauses

2021-07-06 Thread Gilles Darold
Le 07/07/2021 à 06:59, David Rowley a écrit : > On Wed, 7 Jul 2021 at 10:18, Gilles Darold wrote: >> I have noticed that postgres_fdw do not push down the CASE WHEN clauses. In >> the following case this normal: > This looks very similar to [1] which is in the current commitfest. > > Are you able

Re: [PATCH][postgres_fdw] Add push down of CASE WHEN clauses

2021-07-06 Thread David Rowley
On Wed, 7 Jul 2021 at 10:18, Gilles Darold wrote: > I have noticed that postgres_fdw do not push down the CASE WHEN clauses. In > the following case this normal: This looks very similar to [1] which is in the current commitfest. Are you able to look over that patch and check to ensure you're no

[PATCH][postgres_fdw] Add push down of CASE WHEN clauses

2021-07-06 Thread Gilles Darold
Hi, I have noticed that postgres_fdw do not push down the CASE WHEN clauses. In the following case this normal: contrib_regression=# EXPLAIN (ANALYZE, VERBOSE) SELECT (CASE WHEN mod(c1, 4) = 0 THEN 1 ELSE 2 END) FROM ft1;    QUERY PLAN