Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.1) with ESMTP id JAA48530 for ; Mon, 19 Apr 1999 09:39:32 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id JAA03290; Mon, 19 Apr 1999 09:38:15 -0400 (EDT) To: Bill Brandt cc: pgsql-sql@hub.org Subject: Re: [SQL] postgres 6.3.2 and regexp In-reply-to: Your message of Sun, 18 Apr 1999 19:37:31 -0400 <19990418193731.A15075@draaw.net> Date: Mon, 19 Apr 1999 09:38:15 -0400 Message-ID: <3288.924529095@sss.pgh.pa.us> From: Tom Lane Bill Brandt 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