postgres 6.3.2 and regexp

From: Bill Brandt <brandtwr-pgsql(at)draaw(dot)net>
To: pgsql-sql(at)hub(dot)org
Subject: postgres 6.3.2 and regexp
Date: 1999-04-18 23:37:31
Message-ID: 19990418193731.A15075@draaw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 known bug?

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(at)draaw(dot)net http://www.draaw.net/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Shevland 1999-04-19 06:26:56 Re: [SQL] OUTER JOINS
Previous Message Andy Lewis 1999-04-18 18:58:30 Re: [SQL] Case insensitive searchs