Re: [PATCH] proposal for regexp_count, regexp_instr, regexp_substr and regexp_replace
Gilles DAROLD <gilles@darold.net>
From: Gilles Darold <gilles@darold.net>
To: er@xs4all.nl, pgsql-hackers@lists.postgresql.org
Cc: Chapman Flack <chap@anastigmatix.net>
Date: 2021-03-21T13:19:13Z
Lists: pgsql-hackers
Attachments
- v3-0001-xquery-regexp-functions.patch (text/x-patch) patch v3-0001
Le 21/03/2021 à 12:07, er@xs4all.nl a écrit : >> 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 Thanks a lot Erik, here is a version of the patch with your corrections. -- Gilles Darold LzLabs GmbH http://www.lzlabs.com/
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