Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.8.8) with ESMTP id KAA01684 for ; Wed, 16 Sep 1998 10:15:30 -0400 (EDT) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id QAA20256; Wed, 16 Sep 1998 16:14:11 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zJK6r-0006G7-00; Wed, 16 Sep 1998 16:07:13 +0000 Date: Wed, 16 Sep 1998 16:14:20 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <10676.980916@bo.nettuno.it> To: Marcio Macedo , David Hartwig , Barracuda , pgsql-sql@postgresql.org, "S.Ramaswamy" Subject: Re[2]: [SQL] How to Make Case InSensitive??? References: <19980916134810.21155.rocketmail@send101.yahoomail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Hello Barracuda, mercoledì, 16 settembre 98, you wrote: B> thank you for this tip! don't know what the ^ or the $ is used for regular expression operators ^ stand for first character and $ stand for last character: ~* '^india$' matches India india INDIA but not Indiana New India >> B> but the ~* and the \do helped me out a great deal. No info on this in B> any documentation. Take a look at PostgreSQL User's Guide, Chapter 5, there's some information about PostgreSQL operators. B> Charles B> ---David Hartwig wrote: >> >> >> >> Marcio Macedo wrote: >> >> > Hey... >> > >> > How does this " ~* " operator works ?!?!?! >> > >> > David Hartwig wrote: >> > > >> > > >> > > SELECT * FROM series WHERE upper(NAME) = 'INDIA' >> > > or >> > > SELECT * FROM series WHERE NAME ~* '^india$' >> >> > >> >> I don't use it myself, but it is a case insensitive regular expression >> match operator. "~' is the case sensitive operator. Do "\do" in >> psql to see all the operators. >> >> >> B> _________________________________________________________ B> DO YOU YAHOO!? B> Get your free @yahoo.com address at http://mail.yahoo.com Jose'