BUG #8679: Error in regex function

From: spmpro(at)pochta(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8679: Error in regex function
Date: 2013-12-13 08:12:51
Message-ID: E1VrNrf-0001cE-4P@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8679
Logged by: Andrzej
Email address: spmpro(at)pochta(dot)ru
PostgreSQL version: 9.2.0
Operating system: Ubuntu
Description:

Hi, I make command select regexp_replace('rewqe ','(?<=[q]{1})[e]{1}(?=[\-
$]+)','11');
and he return error 'invalid regular expression: quantifier operand
invalid', but regex is correct (check by http://gskinner.com/RegExr/) This
error repeat in another regex function (regexp_matches,
regexp_split_to_array).

But command select regexp_replace('rewqe ','[e]{1}(?=[\- $]+)','11') work
good. May be, regex construction (?<=\pattern\) is not support?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message launchpad 2013-12-13 10:50:12 BUG #8680: Fix initialization of pg_clog and pg_subtrans during hot standby startup
Previous Message Peter Geoghegan 2013-12-12 18:44:32 Re: stats_temp_directory SIGHUP documentation bug