Re: Infinite Interval

Joseph Koshakow <koshy44@gmail.com>

From: Joseph Koshakow <koshy44@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, "Gregory Stark (as CFM)" <stark.cfm@gmail.com>, jian he <jian.universality@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2023-07-08T19:27:51Z

Lists: pgsql-hackers

Attachments

0001-Move-integer-helper-function-to-int.h-20230708.patch (text/x-patch) patch 0001
0003-Add-infinite-interval-values-20230708.patch (text/x-patch) patch 0003
0002-Check-for-overflow-in-make_interval-20230708.patch (text/x-patch) patch 0002

On Sat, Jul 8, 2023 at 2:38 PM Joseph Koshakow <koshy44@gmail.com> wrote:

> I've updated the patch to fix this issue.

That seems to have fixed the cfbot failures. Though I left in an
unused variable. Here's another set of patches with the compiler
warnings fixed.

Thanks,
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