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: https://www.postgresql.org/message-id/20230625.210509.1276733411677577841.t-ishii%40sranhm.sra.co.jp
This talk includes following topics:
- What is RPR?
- How is RPR useful?
- How to implement RPR in PostgreSQL?
- Future plans
- Demonstrations
