Re: Regexp named capture groups

On Sat, Feb 03, 2018 at 01:55:31PM +0100, Pavel Stehule wrote:
> 2018-02-03 11:19 GMT+01:00 Joel Jacobson <joel(at)trustly(dot)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