Any interest in adding match_recognize?

On Oct 9, 2020, at 10:25 AM, Guyren Howe <guyren@gmail.com> wrote:

I just became aware of the SQL 2016 standard match_recognize feature, which allows for rich pattern matching across groups of rows. It’s a great feature, currently only supported in Oracle.

I can find no evidence it’s ever been discussed here and there’s no mention of it on the PG website.

So: is anyone considering adding this feature?

Do you happen to know if Oracle implemented this before or after 2016?

Rob Sargent schrieb am 09.10.2020 um 18:33:

On Oct 9, 2020, at 10:25 AM, Guyren Howe <guyren@gmail.com> wrote:

I just became aware of the SQL 2016 standard match_recognize
feature, which allows for rich pattern matching across groups of
rows. It’s a great feature, currently only supported in Oracle.

I can find no evidence it’s ever been discussed here and there’s no
mention of it on the PG website.

So: is anyone considering adding this feature?

Do you happen to know if Oracle implemented this before or after 2016?

match_recognize was introduced in Oracle 12.1 which was released in 2013

Thomas

On Fri, 2020-10-09 at 09:25 -0700, Guyren Howe wrote:

I can find no evidence it’s ever been discussed here and there’s no mention of it on the PG website.

So: is anyone considering adding this feature?

I think it would be useful, but non-trivial to implement.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com