Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id NAA28262 for ; Sat, 4 Sep 1999 13:39:44 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id KAA10486; Sat, 4 Sep 1999 10:38:40 -0700 From: "tjk@tksoft.com" Message-Id: <199909041738.KAA10486@uno.tksoft.com> Subject: Re: [SQL] select ... from ... where ... ~* 'C++' To: dolog@mcprogress.com (Martin Dolog) Date: Sat, 4 Sep 1999 10:38:40 -0700 (PDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <37D12DB8.F94227A3@mcprogress.com> from "Martin Dolog" at Sep 4, 99 04:33:28 pm Content-Type: text Martin, Try select something from something_t where some ~* 'C[+][+]' or rather, select something from something_t where some like '%C++%' Troy > > > hi *, > > PLease, how can I make case insensitive query > which work with string like 'C++' too ? > > select something from something_t where some ~* 'C++' > > doesn't work! > I got following error message: > > "ERROR: regcomp failed with error repetition-operator operand invalid" > > > I am running on Linux/Redhat6/postgresql6.5 compiled > with --enable-locale flag. > > > Thank you very much for help. > > > > Martin > > -- > > #md > > ************ > >