Re: BUG #19731: `first_value` returns an excluded peer for a nonempty `EXCLUDE TIES` frame

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: theshallow27(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19731: `first_value` returns an excluded peer for a nonempty `EXCLUDE TIES` frame
Date: 2026-10-05 02:35:49
Message-ID: CAGRkXqTwirfFM=ShfkYGJ6UaWy071b=kxrhwVBct6SmpsRT8Gg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

This is the same bug as BUG #19732. That thread has a patch.

https://postgr.es/m/19732-d4eed889e3021ef8@postgresql.org

Thanks,
shihao zhong

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message shihao zhong 2026-10-05 02:39:02 Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f
Previous Message shihao zhong 2026-10-05 02:20:36 Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t"