Received: from perninha.conectiva.com.br (perninha.conectiva.com.br [200.203.180.1]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA22626 for ; Tue, 1 Sep 1998 13:19:12 -0400 (EDT) Received: from conectiva.com.br (animaniacs.conectiva.com.br [200.250.241.2]) by perninha.conectiva.com.br (8.9.0/8.9.0) with ESMTP id OAA03242; Tue, 1 Sep 1998 14:16:30 -0300 Sender: marciom@perninha.conectiva.com.br Message-ID: <35EC0157.950EFE6D@conectiva.com.br> Date: Tue, 01 Sep 1998 14:14:47 +0000 From: Marcio Macedo X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: David Hartwig 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> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hey... How does this " ~* " operator works ?!?!?! David Hartwig wrote: > > > SELECT * FROM series WHERE upper(NAME) = 'INDIA' > or > SELECT * FROM series WHERE NAME ~* '^india$' --Marcio Macedo Conectiva