Re: Infinite Interval

Joseph Koshakow <koshy44@gmail.com>

From: Joseph Koshakow <koshy44@gmail.com>

To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, "Gregory Stark (as CFM)" <stark.cfm@gmail.com>, jian he <jian.universality@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2023-03-25T15:42:58Z

Lists: pgsql-hackers

Attachments

v2-0001-Move-integer-helper-function-to-int.h.patch (text/x-patch) patch v2-0001
v2-0002-Check-for-overflow-in-make_interval.patch (text/x-patch) patch v2-0002

On Fri, Mar 24, 2023 at 9:43 AM Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
wrote:
>
>    You don't need to do this, but looks like we can add DAYS_PER_WEEK
macro and
>    use it here.

I've attached a patch with this new macro. There's probably tons of
places it can be used instead of hardcoding the number 7, but I'll save
that for a future patch.

- Joe Koshakow

Commits

Support +/- infinity in the interval data type.
- 519fc1bd9e9d 17.0 landed
Avoid integer overflow hazard in interval_time().
- 3850d4dec1d9 17.0 landed
Guard against overflow in make_interval().
- b2d55447a563 17.0 landed
Fix minmax-multi on infinite date/timestamp values
- 8da86d62a112 17.0 cited
Optimize various aggregate deserialization functions, take 2
- 0c882a298881 17.0 cited
Remove dead code in DecodeInterval()
- d6d1430f4043 17.0 cited
Accept "+infinity" in date and timestamp[tz] input.
- 2ceea5adb026 16.0 cited
Fix overflow hazards in interval input and output conversions.
- e39f99046710 15.0 cited