postgres 6.3.2 and regexp - Mailing list pgsql-sql

From Bill Brandt
Subject postgres 6.3.2 and regexp
Date
Msg-id 19990418193731.A15075@draaw.net
Whole thread Raw
Responses Re: [SQL] postgres 6.3.2 and regexp
Re: [SQL] postgres 6.3.2 and regexp
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: Andy Lewis
Date:
Subject: Re: [SQL] Case insensitive searchs
Next
From: Joe Shevland
Date:
Subject: Re: [SQL] OUTER JOINS