Re: Patch: regexp_matches variant returning an array of matching positions

Erik Rijkers wrote
> On Wed, January 29, 2014 05:16, David Johnston wrote:
>>
>> How does this resolve in the patch?
>>
>> SELECT regexp_matches('abcabc','((a)(b)(c))','g');
>>
>
> With the patch:
>
> testdb=# SELECT regexp_matches('abcabc','((a)(b)(c))','g'),
> regexp_matches_positions('abcabc','((a)(b)(c))');
> regexp_matches | regexp_matches_positions
> ----------------+--------------------------
> {abc,a,b,c} | {1,1,2,3}
> {abc,a,b,c} | {1,1,2,3}
> (2 rows)

The {1,1,2,3} in the second row is an artifact/copy from
set-value-function-in-select-list repetition and has nothing to do with the
second match.

> testdb=# SELECT regexp_matches('abcabc','((a)(b)(c))','g'),
> regexp_matches_positions('abcabc','((a)(b)(c))', 'g');
> regexp_matches | regexp_matches_positions
> ----------------+--------------------------
> {abc,a,b,c} | {1,1,2,3}
> {abc,a,b,c} | {4,4,5,6}
> (2 rows)

As expected.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Patch-regexp-matches-variant-returning-an-array-of-matching-positions-tp5789321p5789434.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.