Re: BUG #15287: postgres_fdw: the "WHERE date_trunc('day', dt) = 'YYYY-MM-DD' does not push to remote.

From: Ireneusz Pluta <ipluta(at)wp(dot)pl>
To: Andres Freund <andres(at)anarazel(dot)de>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15287: postgres_fdw: the "WHERE date_trunc('day', dt) = 'YYYY-MM-DD' does not push to remote.
Date: 2018-07-20 16:48:09
Message-ID: 9d6b978a-1aff-4f9e-03c6-0489836570d8@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

W dniu 2018-07-20 o 18:39, Andres Freund pisze:

> Hi,
>
> On 2018-07-20 16:31:18 +0000, PG Bug reporting form wrote:
>> the clause:
>> WHERE date_trunc('day'::text, dt::timestamp without time zone) =
>> 'yyyy-mm-dd'
>> does not get shipped to the foreign server.
> You're probably going to have a higher likelihood of getting the bug
> fixed quickly if you'd include a full reproducer.
>
> Greetings,
>
> Andres Freund

Sure, but RhodiumToad was so kind promising to follow up on this, so I skipped that chore :-).

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2018-07-20 16:59:00 Re: BUG #15287: postgres_fdw: the "WHERE date_trunc('day', dt) = 'YYYY-MM-DD' does not push to remote.
Previous Message Andres Freund 2018-07-20 16:39:45 Re: BUG #15287: postgres_fdw: the "WHERE date_trunc('day', dt) = 'YYYY-MM-DD' does not push to remote.