Re: Regexp named capture groups - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Regexp named capture groups
Date
Msg-id 20180203134935.GB5451@paquier.xyz
Whole thread Raw
In response to Re: Regexp named capture groups  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Sat, Feb 03, 2018 at 01:55:31PM +0100, Pavel Stehule wrote:
> 2018-02-03 11:19 GMT+01:00 Joel Jacobson <joel@trustly.com>:
>> Is anyone working on this feature[1] also for PostgreSQL's regex
>> engine?

Note that I know of.

>> I think this feature would be awesome, for the reasons mentioned in [1],
>> quote:
>>
>> "Referring to capture groups via numbers has several disadvantages:
>> 1. Finding the number of a capture group is a hassle: you have to
>> count parentheses.
>> 2. You need to see the regular expression if you want to understand
>> what the groups are for.
>> 3. If you change the order of the capture groups, you also have to
>> change the matching code."
>>
>> [1] http://2ality.com/2017/05/regexp-named-capture-groups.html
>
> looks like nice feature

Yes, it looks that this could allow the simplification of equivalent
queries, which I guess would use a CTE to achieve the same.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Regexp named capture groups
Next
From: Andreas Karlsson
Date:
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays