BUG #8679: Error in regex function - Mailing list pgsql-bugs

From spmpro@pochta.ru
Subject BUG #8679: Error in regex function
Date
Msg-id E1VrNrf-0001cE-4P@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8679: Error in regex function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8679
Logged by:          Andrzej
Email address:      spmpro@pochta.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?

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: stats_temp_directory SIGHUP documentation bug
Next
From: anitchakkarwar@gmail.com
Date:
Subject: BUG #8681: column 'n_tup_del' of pg_stat_user_tables doesn't change in case of truncate