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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers