Any interest in adding match_recognize?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Any interest in adding match_recognize?

Guyren Howe
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?
lup
Reply | Threaded
Open this post in threaded view
|

Re: Any interest in adding match_recognize?

lup

> On Oct 9, 2020, at 10:25 AM, Guyren Howe <[hidden email]> 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?



Reply | Threaded
Open this post in threaded view
|

Re: Any interest in adding match_recognize?

Thomas Kellerer-4
Rob Sargent schrieb am 09.10.2020 um 18:33:

>> On Oct 9, 2020, at 10:25 AM, Guyren Howe <[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

Re: Any interest in adding match_recognize?

Laurenz Albe
In reply to this post by Guyren Howe
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