Horton

Re: Case expression pushdown

Alexander Pyhalov <a.pyhalov@postgrespro.ru>

View thread View on postgr.es
From: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
To: Seino Yuki <seinoyu@oss.nttdata.com>
Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-06-22T13:39:43Z
Lists: pgsql-hackers

Attachments

Seino Yuki писал 2021-06-22 16:03:
> On 2021-06-16 01:29, Alexander Pyhalov wrote:
>> Hi.
>> 
>> Ashutosh Bapat писал 2021-06-15 16:24:
>>> Looks quite useful to me. Can you please add this to the next 
>>> commitfest?
>>> 
>> 
>> Addded to commitfest. Here is an updated patch version.
> 
> Thanks for posting the patch.
> I agree with this content.
> 
>> + Foreign Scan on public.ft2  (cost=156.58..165.45 rows=394 width=14)
> It's not a big issue, but is there any intention behind the pattern of
> outputting costs in regression tests?

Hi.

No, I don't think it makes much sense. Updated tests (also added case 
with empty else).
-- 
Best regards,
Alexander Pyhalov,
Postgres Professional

Commits

  1. In postgres_fdw, allow CASE expressions to be pushed to the remote server.