Viktor Rosenfeld <listuser36@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general