>-Oprindelig meddelelse-
>Fra: Francisco Olarte
>Sendt: 10. april 2021 09:31
>Til: Niels Jespersen
>
>Although it is equivalent I would suggest to use:
>
>f.r_time< ('2020-10-01 00:00:00+00'::timestamptz at time zone 'utc' + interval
>'1 month') at time zone 'utc' ;
>
>optimizer should
>-Oprindelig meddelelse-
>Fra: Tom Lane
>Emne: Re: where clauses including timstamptz and intervals
>
>Ron writes:
>> On 4/9/21 5:24 AM, hubert depesz lubaczewski wrote:
>>> For example, in my timezone:
>>>
>>> (1 row)
>>>
>>> Please note that there is 1 hour difference.
>>> The reason