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.