Re: abs function for interval

2019-11-27 Thread Michael Paquier
On Fri, Nov 01, 2019 at 12:48:50AM -0300, Euler Taveira wrote: > Hmm. Good idea. Let me try it. Marked as RwF, as this has not been updated in four weeks. Please feel free to resubmit later once you have an updated version. -- Michael signature.asc Description: PGP signature

Re: abs function for interval

2019-10-31 Thread Euler Taveira
Em qui, 31 de out de 2019 às 23:45, Andres Freund escreveu: > > 1) I don't think you can do the < 0 check on an elementwise basis. Your >code would e.g. make a hash out of abs('1 day -1 second'), by >inverting the second, but not the day (whereas nothing should be >done). > >It'd

Re: abs function for interval

2019-10-31 Thread Andres Freund
Hi, On 2019-10-31 23:20:07 -0300, Euler Taveira wrote: > diff --git a/src/backend/utils/adt/timestamp.c > b/src/backend/utils/adt/timestamp.c > index 1dc4c820de..a6b8b8c221 100644 > --- a/src/backend/utils/adt/timestamp.c > +++ b/src/backend/utils/adt/timestamp.c > @@ -2435,6 +2435,23 @@

abs function for interval

2019-10-31 Thread Euler Taveira
rom b11a05e3304250803c7aa2ac811e0d49b0adfc00 Mon Sep 17 00:00:00 2001 From: Euler Taveira Date: Thu, 31 Oct 2019 23:07:00 -0300 Subject: [PATCH] Add abs function for interval. Sometimes you want to answer if a difference between two timestamps is lesser than x minutes. However, if you cannot obtain the absolute value of subtract