[GENERAL] regexp_matches() quantified-capturing-parentheses oddity

[Julian Mehnle]

Hi all,

  wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', '([...@.]|[...@.]+)', 
'g');
   {quux}
   {...@}
   {foo}
   {...@}
   {bar}
   {.}
   {zip}

So far, so good.  However, can someone please explain the following to me?

  wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', '([...@.]|[...@.]+)+', 
'g');
   {p}

  wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', 
'([...@.]|[...@.]+){1,2}', 'g');
   {...@}
   {...@}
   {.}
   {p}

  wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', 
'([...@.]|[...@.]+){1,3}', 'g');
   {foo}
   {.}
   {p}

What's going on here??

Regards,

-Julian Mehnle

signature.asc
Description: This is a digitally signed message part.