SV: where clauses including timstamptz and intervals

2021-04-15 Thread Niels Jespersen
>-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

SV: where clauses including timstamptz and intervals

2021-04-09 Thread Niels Jespersen
>-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