Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG? Regular expression matching of optional character group at beginning of RE - Mailing list pgsql-general

From Tom Lane
Subject Re: BUG? Regular expression matching of optional character group at beginning of RE
Date
Msg-id 23411.1341677363@sss.pgh.pa.us
Whole thread Raw
In response to BUG? Regular expression matching of optional character group at beginning of RE  (Viktor Rosenfeld <listuser36@googlemail.com>)
List pgsql-general
Tree view 
Viktor Rosenfeld <listuser36@googlemail.com> writes:
> I've noticed that regular expressions which are anchored at the
> beginning of the text but have an optional part at the beginning
> (e.g. '^(ge)?kommen$') are not evaluated correctly if there is an
> index on the column.

Ugh.  Yeah, that's a bug, and it looks a bit messy to fix ...

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: Help with sql
Next
From: Wim Goedertier
Date:
Subject: recover as much as possible (xlog flush request not satisfied)