Schedule - PostgreSQL Development Conference 2024

Implementing Row Pattern Recognition

Date: 2024-05-29
Time: 16:00–16:50
Room: Canfor(1600)
Level: Intermediate

Row pattern recognition (RPR) has been defined since SQL:2016. RPR is a powerful feature to analyze complex data, especially series of data. With RPR you can find specific trends in a sequence of rows by defining search conditions and regular expressions. Currently we are working on implementing RPR in PostgreSQL's Window clause:

This talk includes following topics:

  • What is RPR?
  • How is RPR useful?
  • How to implement RPR in PostgreSQL?
  • Future plans
  • Demonstrations


Tatsuo Ishii