Received: from draaw.net (qmailr@puma.draaw.net [199.234.237.21]) by hub.org (8.9.3/8.9.1) with SMTP id TAA12166 for ; Sun, 18 Apr 1999 19:37:39 -0400 (EDT) (envelope-from bbrandt@draaw.net) Received: (qmail 15173 invoked by uid 501); 18 Apr 1999 23:37:31 -0000 Date: Sun, 18 Apr 1999 19:37:31 -0400 From: Bill Brandt To: pgsql-sql@hub.org Subject: postgres 6.3.2 and regexp Message-ID: <19990418193731.A15075@draaw.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95us 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@draaw.net http://www.draaw.net/