This may have been dealt with before, but I'm encountering a problem with regexp selects in postgres 6.3.2. Is this a
knownbug?
If I insert a value of '*test*' into an field and do a select like:
select * from table where 'This is a test entry'::text~*field;
I get a reply of:
ERROR: regcomp failed with error repetition-operator operand invalid
This happens anytime the text has a * as the first character.
--
Bill Brandt
brandtwr@draaw.net http://www.draaw.net/