Re: Re: Patch: regexp_matches variant returning an array of matching positions - Mailing list pgsql-hackers

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)
)