Horton

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

Erik Rijkers <er@xs4all.nl>

View thread View on postgr.es
From: Erik Rijkers <er@xs4all.nl>
To: Gilles Darold <gilles@darold.net>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org, chap@anastigmatix.net
Date: 2021-08-03T13:02:43Z
Lists: pgsql-hackers 
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.


Erik Rijkers


> 
> 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,
>

Commits

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

  2. Add assorted new regexp_xxx SQL functions.