Re: +infinity for dates and timestamps

2023-01-01 Thread Vik Fearing
On 1/1/23 20:21, Tom Lane wrote: Vik Fearing writes: Hmm. Somehow the .out test files were not included. Fixed with attached. Somehow you'd managed to duplicate some of the other changes, so the cfbot still didn't like that :-( Anyway, pushed with cosmetic changes. Notably, I left out the

Re: +infinity for dates and timestamps

2023-01-01 Thread Tom Lane
Vik Fearing writes: > Hmm. Somehow the .out test files were not included. > Fixed with attached. Somehow you'd managed to duplicate some of the other changes, so the cfbot still didn't like that :-( Anyway, pushed with cosmetic changes. Notably, I left out the documentation changes after obser

Re: +infinity for dates and timestamps

2022-12-31 Thread Tom Lane
Vik Fearing writes: > It has always annoyed me that we can't write '+infinity' for dates and > timestamps and get the OCD satisfaction of making our queries line up > with '-infinity'. +1, since it works for numerics it should work for these types to

Re: +infinity for dates and timestamps

2022-12-31 Thread Vik Fearing
On 1/1/23 03:10, Vik Fearing wrote: It has always annoyed me that we can't write '+infinity' for dates and timestamps and get the OCD satisfaction of making our queries line up with '-infinity'. I wrote a fix for that some time ago but apparently never posted it. 

+infinity for dates and timestamps

2022-12-31 Thread Vik Fearing
It has always annoyed me that we can't write '+infinity' for dates and timestamps and get the OCD satisfaction of making our queries line up with '-infinity'. I wrote a fix for that some time ago but apparently never posted it. I was reminded of it by jian he in the