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

Gilles DAROLD <gilles@darold.net>

View thread View on postgr.es

From: Gilles Darold <gilles@darold.net>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: pgsql-hackers@lists.postgresql.org, chap@anastigmatix.net, er@xs4all.nl

Date: 2021-08-03T11:26:48Z

Lists: pgsql-hackers

Attachments

v7-0001-regexp-foo-functions.patch (text/x-patch) patch v7-0001

Le 03/08/2021 à 11:45, Gilles Darold a écrit :
> Actually I just found that the regexp_like() function doesn't support 
> the start parameter which is something we should support. I saw that 
> Oracle do not support it but DB2 does and I think we should also 
> support it. I will post a new version of the patch once it is done.


Here is a new version of the patch that adds the start parameter to 
regexp_like() function but while I'm adding support to this parameter it 
become less obvious for me that we should implement it. However feel 
free to not use this version if you think that adding the start 
parameter has no real interest.


Best regards,

-- 
Gilles Darold

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