xocolatl/extra_window_functions v2.0

on GitHub

New functions

• group_number(), ema(), interpolate()
• run_length() / run_position(), most_common(), avg_percent_rank()
• count_ties(), avg_rank()

Other changes

• The extension is now relocatable
• Compatibility updated through PG15
• GitHub Actions CI for the regression tests (Travis removed)
• Expanded and polished README
• The *_ignore_nulls functions are obsolete on PostgreSQL 19, which adds the
  standard IGNORE NULLS clause. nth_value_from_last remains useful on every
  version, since FROM LAST is still unimplemented.

Upgrading

From 1.0:

ALTER EXTENSION extra_window_functions UPDATE;

Full Changelog: v1.0...v2.0