Horton

Re: btree_gin: Incorrect leftmost interval value

Dean Rasheed <dean.a.rasheed@gmail.com>

View thread View on postgr.es
From: Dean Rasheed <dean.a.rasheed@gmail.com>
To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-10-27T13:05:21Z
Lists: pgsql-hackers 
On Fri, 27 Oct 2023 at 13:56, Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> Should we change this to call INTERVAL_NOBEGIN() to be added by
> infinite interval patches?
>

Given that this is a bug that can lead to incorrect query results, I
plan to back-patch it, and INTERVAL_NOBEGIN() wouldn't make sense in
back-branches that don't have infinite intervals.

Regards,
Dean

Commits

  1. btree_gin: Fix calculation of leftmost interval value.