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

Harald Fuchs writes: > Tom Lane writes: >> Julian Mehnle writes: >>> So far, so good. However, can someone please explain the following to me? >>> wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', '([...@.]|[...@.]+)+', >>> 'g'); >>> wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', >>>

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

In article <13289.1260290...@sss.pgh.pa.us>, Tom Lane writes: > Julian Mehnle writes: >> So far, so good. However, can someone please explain the following to me? >> wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', '([...@.]|[...@.]+)+', >> 'g'); >> wisu-dev=# SELECT regexp_matches('q...@f

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

Tom, thanks for your reply. I wrote: > 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

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

Julian Mehnle writes: > So far, so good. However, can someone please explain the following to me? > wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', '([...@.]|[...@.]+)+', > 'g'); > wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', > '([...@.]|[...@.]+){1,2}', 'g'); > wisu-dev=# SE

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

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', '([...@.]|