Re: [PATCH] proposal for regexp_count, regexp_instr, regexp_substr and regexp_replace
Erik Rijkers <er@xs4all.nl>
From: er@xs4all.nl
To: Gilles Darold <gilles@darold.net>, pgsql-hackers@lists.postgresql.org
Cc: Chapman Flack <chap@anastigmatix.net>
Date: 2021-03-21T11:07:37Z
Lists: pgsql-hackers
Attachments
- func.sgml.20210321.diff (text/x-patch) patch
- pg_proc.dat.20210321.diff (text/x-patch) patch
> On 2021.03.20. 19:48 Gilles Darold <gilles@darold.net> wrote: > > This is a new version of the patch that now implements all the XQUERY > regexp functions as described in the standard, minus the differences of > PostgerSQL regular expression explain in [1]. > > The standard SQL describe functions like_regex(), occurrences_regex(), > position_regex(), substring_regex() and translate_regex() which > correspond to the commonly named functions regexp_like(), > regexp_count(), regexp_instr(), regexp_substr() and regexp_replace() as > reported by Chapman Flack in [2]. All these function are implemented in > [v2-0001-xquery-regexp-functions.patch] Hi, Apply, compile and (world)check are fine. I haven't found errors in functionality. I went through the docs, and came up with these changes in func.sgml, and pg_proc.dat. Useful functions - thanks! Erik Rijkers
Commits
-
doc: More documentation on regular expressions and SQL standard
- 222b697ec077 15.0 landed
-
Add assorted new regexp_xxx SQL functions.
- 642433707358 15.0 landed