Re: truncating timestamps on arbitrary intervals - Mailing list pgsql-hackers

From John Naylor
Subject Re: truncating timestamps on arbitrary intervals
Date
Msg-id CAFBsxsE1D8buF1xeGFi6FYghxEhnoBGHAngDE52KK-8O2KOd4g@mail.gmail.com
Whole thread Raw
In response to Re: truncating timestamps on arbitrary intervals  (Bauyrzhan Sakhariyev <baurzhansahariev@gmail.com>)
Responses Re: truncating timestamps on arbitrary intervals  (Bauyrzhan Sakhariyev <baurzhansahariev@gmail.com>)
List pgsql-hackers

On Thu, Jul 22, 2021 at 12:24 PM Bauyrzhan Sakhariyev <baurzhansahariev@gmail.com> wrote:
>
> Is date_bin supposed to return the beginning of the bin?

Thanks for testing! And yes.

> And does the sign of an interval define the "direction" of the bin?

No, the boundary is intentionally the earlier one:

/*
 * Make sure the returned timestamp is at the start of the bin, even if
 * the origin is in the future.
 */
if (origin > timestamp && stride_usecs > 1)
    tm_delta -= stride_usecs;

I wonder if we should just disallow negative intervals here.

--
John Naylor
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Arne Roland
Date:
Subject: Re: Rename of triggers for partitioned tables
Next
From: Mark Dilger
Date:
Subject: Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)