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 p

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 @@ interval