Re: truncating timestamps on arbitrary intervals

On 1/18/21 3:54 PM, John Naylor wrote:
> On Mon, Nov 23, 2020 at 1:44 PM John Naylor
> <john(dot)naylor(at)enterprisedb(dot)com <mailto:john(dot)naylor(at)enterprisedb(dot)com>> wrote:
> >
> > On Thu, Nov 12, 2020 at 9:56 AM Peter Eisentraut
> <peter(dot)eisentraut(at)enterprisedb(dot)com
> <mailto:peter(dot)eisentraut(at)enterprisedb(dot)com>> wrote:
> > > - After reading the discussion a few times, I'm not so sure anymore
> > > whether making this a cousin of date_trunc is the right way to go.  As
> > > you mentioned, there are some behaviors specific to date_trunc that
> > > don't really make sense in date_trunc_interval, and maybe we'll have
> > > more of those.
>
> For v10, I simplified the behavior by decoupling the behavior from
> date_trunc() and putting in some restrictions as discussed earlier. It's
> much simpler now. It could be argued that it goes too far in that
> direction, but it's easy to reason about and we can put back some
> features as we see fit.

Peter, thoughts on the new patch?

Regards,
--
-David
david(at)pgmasters(dot)net