"Emulating" MATCH_RECOGNIZE in PostgreSQL
Things that happen on a bank holiday...
So, this morning I was made aware of this blog post covering a rather new (completely new to me, TBTH) SQL:2016 feature, MATCH_RECOGNIZE
, as something that could be added to PostgreSQL.
The example challenge in the blog post is to find "cases" peaks in COVID-19 data.