Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options

[Oliver Ford]

On Thu, Jan 23, 2025 at 6:27 AM Tatsuo Ishii <is...@postgresql.org> wrote:
>
> Another possible problem is, probably the code does not work well if
> there are multiple partitions. Since win_nonnulls stores currentpos in
> a partition, when the partition ends, win_nonnulls needs to be
> reset. Otherwise, it mistakenly represents currentpos in the previous
> partition.
>
The attached patch should fix both of these. I've added extra tests
with a PARTITION BY in the window clause to test for multiple
partitions.

0005-ignore-nulls.patch
Description: Binary data