Received: from send101.yahoomail.com (send101.yahoomail.com [205.180.60.87]) by hub.org (8.8.8/8.8.8) with SMTP id JAA28860 for ; Wed, 16 Sep 1998 09:48:31 -0400 (EDT) (envelope-from cuda_fx@yahoo.com) Message-ID: <19980916134810.21155.rocketmail@send101.yahoomail.com> Received: from [208.135.152.110] by send101.yahoomail.com; Wed, 16 Sep 1998 06:48:10 PDT Date: Wed, 16 Sep 1998 06:48:10 -0700 (PDT) From: Barracuda Subject: Re: [SQL] How to Make Case InSensitive??? To: Marcio Macedo , David Hartwig Cc: pgsql-sql@postgreSQL.org, "S.Ramaswamy" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii thank you for this tip! don't know what the ^ or the $ is used for but the ~* and the \do helped me out a great deal. No info on this in any documentation. Charles ---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. > > > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com