Received: from fork.computel.sk (fork.computel.sk [195.28.96.96]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA97722 for ; Sat, 4 Sep 1999 10:26:39 -0400 (EDT) (envelope-from dolog@mcprogress.com) Received: from mcprogress.com (c137.computel.sk [195.28.100.137]) by fork.computel.sk with ESMTP id QAA10017 for ; Sat, 4 Sep 1999 16:26:08 +0200 Sender: lipa@computel.sk Message-ID: <37D12DB8.F94227A3@mcprogress.com> Date: Sat, 04 Sep 1999 16:33:28 +0200 From: Martin Dolog Organization: MC progress X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.5-22 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: select ... from ... where ... ~* 'C++' Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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