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

From Erik Rijkers
Subject Re: BUG #8679: Error in regex function
Date
Msg-id 1e4f6c4f59006753c3e00b77b9481147.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to Re: BUG #8679: Error in regex function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, December 13, 2013 18:40, Tom Lane wrote:
> spmpro@pochta.ru writes:
>> May be, regex construction (?<=\pattern\) is not support?
>
> It is not.  What we support is documented at
> http://www.postgresql.org/docs/9.2/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP
>
> I have no idea what "(?<=" is supposed to mean --- it's not a standard

FWIW, perl has these; see http://perldoc.perl.org/perlre.html (search for "Look-Around Assertions" ):

   (?<=pattern)   A zero-width positive look-behind assertion

   (?<!pattern)   A zero-width negative look-behind assertion.


It would certainly be nice if these would implemented in postgres...

pgsql-bugs by date:

Previous
From: david fleischhauer
Date:
Subject: permission issues with PostgreSQL 9.2 EnterpriseDB one-click installer on windows 7 causes initcluster to fail
Next
From: Maciek Sakrejda
Date:
Subject: Re: BUG #8656: Duplicate data violating unique constraints