Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY)

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: BHUVAN CHILUKUTI <c(dot)bhuvan(at)iitg(dot)ac(dot)in>
Cc: Tatsuo Ishii <ishii(at)postgresql(dot)org>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY)
Date: 2026-10-25 21:37:12
Message-ID: CAGRkXqSekDdbnGvU9kYM1NYLAkwUacdQ9x-=qHPewxPmuXPN-A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Bhuvan,

Thanks, v2 looks good tp me.

Tatsuo said he can look after Nov 3, so I think we just wait.

Thanks,
Shihao

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Manu 2026-10-25 22:58:16 Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction
Previous Message David Rowley 2026-10-25 21:27:00 Re: BUG #19783: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out