Horton

Re: [PATCH] proposal for regexp_count, regexp_instr, regexp_substr and regexp_replace

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Gilles Darold <gilles@darold.net>
Cc: Erik Rijkers <er@xs4all.nl>, pgsql-hackers@lists.postgresql.org, chap@anastigmatix.net
Date: 2021-12-15T12:41:16Z
Lists: pgsql-hackers

Attachments

On 03.08.21 19:10, Tom Lane wrote:
> Gilles Darold <gilles@darold.net> writes:
>> Sorry I have missed that, but I'm fine with this implemenation so let's
>> keep the v6 version of the patch and drop this one.
> 
> Pushed, then.  There's still lots of time to tweak the behavior of course.

I have a documentation follow-up to this.  It seems that these new 
functions are almost a de facto standard, whereas the SQL-standard 
functions are not implemented anywhere.  I propose the attached patch to 
update the subsection in the pattern-matching section to give more 
detail on this and suggest equivalent functions among these newly added 
ones.  What do you think?

Commits

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

  2. Add assorted new regexp_xxx SQL functions.