Re: BUG #4044: Incorrect RegExp substring Output - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4044: Incorrect RegExp substring Output
Date
Msg-id 7260.1206021713@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4044: Incorrect RegExp substring Output  ("Rui Martins" <Rui.Martins@PDMFC.com>)
Responses Re: BUG #4044: Incorrect RegExp substring Output  ("Rui Martins" <Rui.Martins@PDMFC.com>)
List pgsql-bugs
"Rui Martins" <Rui.Martins@PDMFC.com> writes:
> My reasoning is:
> Why would the exact same sub-expression, return different results when
> either preceded or followed by something.

It *isn't* returning different results; you are testing for different
things in these two cases, namely whether there is a match to the whole
pattern or just a parenthesized subpattern.  In none of these examples
was there any match to '(something)' --- there couldn't possibly be,
because "something" isn't in the data string.

            regards, tom lane

pgsql-bugs by date:

Previous
From: NikhilS
Date:
Subject: Re: Problem identifying constraints which should not be inherited
Next
From: Tom Lane
Date:
Subject: Re: Problem identifying constraints which should not be inherited