Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA26027 for ; Tue, 1 Sep 1998 14:11:54 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA14464 for pgsql-sql@postgreSQL.org; Tue, 1 Sep 1998 14:01:02 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA34591; Tue, 1 Sep 1998 13:43:48 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA80072; Tue, 1 Sep 1998 13:43:48 -0400 Message-Id: <35EC3349.FE4C20FC@insightdist.com> Date: Tue, 01 Sep 1998 13:47:53 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Marcio Macedo Cc: "S.Ramaswamy" , pgsql-sql@postgreSQL.org Subject: Re: [SQL] How to Make Case InSensitive??? References: <35EC1A87.A9943@giasdl01.vsnl.net.in> <35EC1F0E.F300470F@insightdist.com> <35EC0157.950EFE6D@conectiva.com.br> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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.