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

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)

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)

( in HEAD:

testdb=# SELECT regexp_matches('abcabc','((a)(b)(c))','g');
regexp_matches
----------------
{abc,a,b,c}
{abc,a,b,c}
(2 rows)
)