Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

The analytical window function lead does not support ignoring NULL values. One workaround is to to use the analytical window fucntion first_value which supports ignoring NULL values.

first_value(my_col IGNORE NULLS …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Nil represents an emptry List of anything of zero length. It is not that it refers to nothing but it refers to List which has no contents. In other words, Nil …