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: Tom Lane <tgl@sss.pgh.pa.us>, Erik Rijkers <er@xs4all.nl>
Cc: Gilles Darold <gilles@darold.net>, pgsql-hackers@lists.postgresql.org,
chap@anastigmatix.net
Date: 2021-08-03T14:11:24Z
Lists: pgsql-hackers
Le 03/08/2021 à 15:39, Tom Lane a écrit : > Erik Rijkers <er@xs4all.nl> writes: >> On 8/3/21 1:26 PM, Gilles Darold wrote: >>> 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. >> +1 >> I for one am in favor of this 'start'-argument addition. Slightly >> harder usage, but more precise manipulation. > As I said upthread, I am *not* in favor of making those DB2 additions. > We do not need to create ambiguities around those functions like the > one we have for regexp_replace. If Oracle doesn't have those options, > why do we need them? 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. -- 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