Re: regexp_positions()

2021-02-28 Thread Joel Jacobson
I had a bug in the function, and I see I also accidentally renamed it to regexp_ranges(). Attached is a fixed version of the PoC. This function is e.g. useful when we're interested in patterns in meta-data, where we're not actually finding patterns in the data, but in a string where each charact

Re: regexp_positions()

2021-02-27 Thread Joel Jacobson
Hi, On Sun, Feb 28, 2021, at 03:13, David Fetter wrote: > Maybe an int4multirange, which would fit unless I'm misunderstanding > g's meaning with respect to non-overlapping patterns, but that might > be a little too cute and not easy ever to extend. > > Come to that, would a row structure that lo

Re: regexp_positions()

2021-02-27 Thread David Fetter
On Sat, Feb 27, 2021 at 08:51:27PM +0100, Joel Jacobson wrote: > Hi, > > Finding all matches in a string is convenient using regexp_matches() with the > 'g' flag. > > But if instead wanting to know the start and end positions of the occurrences, > one would have to first call regexp_matches(...,