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

> 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

  1. doc: More documentation on regular expressions and SQL standard

  2. Add assorted new regexp_xxx SQL functions.