add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
id value lag_ignore_nulls value_arr
1 100 100 {100}
2 null 100 {100}
3 null 100 {100}
4 null 100 {100}
5 null 100 {100}
6 null 100 {100}
7 null 100 {100}
8 200 200 {100,200}
9 null 200 {100,200}
SELECT 9