Re: Infinite Interval

From: Joseph Koshakow <koshy44(at)gmail(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Gregory Stark (as CFM)" <stark(dot)cfm(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Infinite Interval
Date: 2023-04-12 18:35:02
Message-ID: CAAvxfHf5qQ5CP2-OWSoVnG47zB3QSZXja8ZSb+NP1hh9udQqQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 12, 2023 at 9:11 AM Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
wrote:

> I modified this to WHERE isfinite(t.f1) or isfinite(d.f1). The output
> contains a lot of additions with infinity::interval but that might be
> ok. No errors.

Attached is a patch with this testing change.

Thanks,
Joe Koshakow

Attachment Content-Type Size
v3-0001-Move-integer-helper-function-to-int.h.patch text/x-patch 3.3 KB
v20-0003-Add-infinite-interval-values.patch text/x-patch 96.7 KB
v3-0002-Check-for-overflow-in-make_interval.patch text/x-patch 5.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2023-04-12 18:36:43 Re: testing sepgsql in CI
Previous Message Jacob Champion 2023-04-12 18:24:33 Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security