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






-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to