Received: from gabuzo.meunet (IDENT:root@ppp-164-107.villette.club-internet.fr [195.36.164.107]) by hub.org (8.9.1/8.9.1) with ESMTP id RAA28313 for ; Thu, 7 Jan 1999 17:35:33 -0500 (EST) (envelope-from labouiss@club-internet.fr) Received: (from moi@localhost) by gabuzo.meunet (8.8.7/8.8.7/Christophe Labouisse d'après Denis BRAUSSEN - 15/mar/98') id XAA12277; Thu, 7 Jan 1999 23:25:50 +0100 To: pgsql-sql@postgreSQL.org Subject: Case insensitive equality operator Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: multipart/mixed; boundary="Multipart_Thu_Jan__7_23:25:49_1999-1" Content-Transfer-Encoding: 7bit From: Christophe Labouisse Date: 07 Jan 1999 23:25:49 +0100 Message-ID: Lines: 25 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" --Multipart_Thu_Jan__7_23:25:49_1999-1 Content-Type: text/plain; charset=US-ASCII I'm looking for a case insensitive equality operator (something like ~~*). There are of course regular expression matches but I am reluctent to use them because I need to preprocess my string before using it (putting it between a ^ and a $, escaping special characters) and because I'm afraid that the use of regular expressions will be more resource demanding than a simple equality. Any ideas ? Cheers --Multipart_Thu_Jan__7_23:25:49_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Christophe Labouisse : Cinéma, typographie, Unix labouiss@club-internet.fr http://gabuzo.home.ml.org/ Le cinéma en Lumière : http://www.lumiere.org/ --Multipart_Thu_Jan__7_23:25:49_1999-1--