Re: Any interest in adding match_recognize? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Any interest in adding match_recognize?
Date
Msg-id 4638ba28-4c83-a670-1a0e-3f28d603d9d8@gmx.net
Whole thread Raw
In response to Re: Any interest in adding match_recognize?  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Any interest in adding match_recognize?
Next
From: Yessica Brinkmann
Date:
Subject: Re: Gurjeet Singh Index Adviser User Interface