Allen Fair <dba@xxxxxxxxxxx> writes: > Hi! I have a table with a character column (called match_regex) > containing a POSIX regular expression, hoping to have Postgres use it > while evaluating the "where" predicate. The following error occurs: > SELECT * > from patterns > where 'blah blah blah' ~ match_regex; > ERROR: invalid regular expression: quantifier operand invalid This means there's at least one value in the column that's not a legal regex (* at the front is one possible cause, IIRC). regards, tom lane
