Thread: Any interest in adding match_recognize?
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?
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?
> 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 groupsof 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