Received: from Fallon.classyad.com (root@classyad.com [152.160.43.1]) by hub.org (8.8.8/8.7.5) with ESMTP id UAA19330 for ; Mon, 13 Jul 1998 20:02:15 -0400 (EDT) Received: from localhost (IDENT:marc@localhost [127.0.0.1]) by Fallon.classyad.com (8.9.0/8.9.0) with SMTP id TAA02200; Mon, 13 Jul 1998 19:56:28 -0400 Date: Mon, 13 Jul 1998 19:56:27 -0400 (EDT) From: Marc Howard Zuckman To: Lorenzo Huerta cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] case-insensitive lookups... In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Mon, 13 Jul 1998, Lorenzo Huerta wrote: > > is there a way to do selects /etc on fields without regard to upper/lower > case of the data in the fields? select * from tablename where attribute ~* 'stringvalue' ; ^^ the case insensitive regex equality operator. Marc Zuckman marc@fallon.classyad.com _\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ _ Visit The Home and Condo MarketPlace _ _ http://www.ClassyAd.com _ _ _ _ FREE basic property listings/advertisements and searches. _ _ _ _ Try our premium, yet inexpensive services for a real _ _ selling or buying edge! _ _\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_