BUG #4580: select substring ('a' from '(b)?(a)') returns null

From: "substring and regular expresssion" <m(dot)mamin(at)intershop(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4580: select substring ('a' from '(b)?(a)') returns null
Date: 2008-12-15 12:56:47
Message-ID: 200812151256.mBFCulva092412@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4580
Logged by: substring and regular expresssion
Email address: m(dot)mamin(at)intershop(dot)de
PostgreSQL version: 8.3.5
Operating system: Linux
Description: select substring ('a' from '(b)?(a)') returns null
Details:

Hello,

substring ('a' from '(b)?(a)') returns 'a' in version 8.2.x,
but null with 8.3.5. Comparing this to the bug entry
http://archives.postgresql.org/pgsql-bugs/2008-11/msg00112.php I guess this
is not considered as a bug and can be fixed while surrounding the regexp
with parenthensis:
substring ('a' from '((b)?(a))')

What I really miss, is the possibility to use the regex_flavor configuration
to get the old behaviour back.
I'm currently preparing an upgrade from 8.2.4 to 8.3.5 and this issue will
probably require a very large code review for us.

Cheers,

Marc Mamin

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-12-15 13:40:02 Re: BUG #4580: select substring ('a' from '(b)?(a)') returns null
Previous Message Sameer Mahajan 2008-12-15 11:45:19 Re: BUG #4568: sporadic error doing COUNT(*) on empty table