Bill Brandt <brandtwr-pgsql(at)draaw(dot)net> writes:
> This may have been dealt with before, but I'm encountering a problem
> with regexp selects in postgres 6.3.2. Is this a known bug?
> ERROR: regcomp failed with error repetition-operator operand invalid
> This happens anytime the text has a * as the first character.
No bug there. Better go reread the documentation about regular
expressions again. (Hint: they're not the same as shell wildcards.)
regards, tom lane