BUG #8605: Regular expression lazy quantification issue - Mailing list pgsql-bugs

From atoriwork@gmail.com
Subject BUG #8605: Regular expression lazy quantification issue
Date
Msg-id E1ViizF-0004K5-5f@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8605: Regular expression lazy quantification issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8605
Logged by:          Atori
Email address:      atoriwork@gmail.com
PostgreSQL version: 9.2.4
Operating system:   Debian 4.7.2-5, 64-bit
Description:

Lazy quantificators does't work after "or" block in regexp mask
('(a)|(b)'):
example:
string: 'CsssQsDpppppQsDpppQ'
mask: '((a)|(C.+?Q))s(D.+?Q)'


select regexp_replace('CsssQsDpppppQsDpppQ', '((C.+?Q))s(D.+?Q)', '#foo#');
result: "#foo#sDpppQ"


select regexp_replace('CsssQsDpppppQsDpppQ', '((a)|(C.+?Q))s(D.+?Q)',
'#foo#');
result: "#foo#"
expected result: "#foo#sDpppQ"

pgsql-bugs by date:

Previous
From: j.rejda@konektel.cz
Date:
Subject: BUG #8606: Materialized View WITH NO DATA bug
Next
From: Tom Lane
Date:
Subject: Re: BUG #8605: Regular expression lazy quantification issue