Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.8.8/8.8.8) with ESMTP id SAA15020 for ; Sat, 19 Sep 1998 18:49:20 -0400 (EDT) (envelope-from les@Mercury.mcs.net) Received: from Mercury.mcs.net (les@Mercury.mcs.net [192.160.127.80]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id RAA18722; Sat, 19 Sep 1998 17:49:04 -0500 (CDT) Received: (from les@localhost) by Mercury.mcs.net (8.8.7/8.8.2) id RAA19174; Sat, 19 Sep 1998 17:48:50 -0500 (CDT) From: Leslie Mikesell Message-Id: <199809192248.RAA19174@Mercury.mcs.net> Subject: Re: [SQL] How to Make Case InSensitive??? To: maillist@candle.pha.pa.us (Bruce Momjian) Date: Sat, 19 Sep 1998 17:48:50 -0500 (CDT) Cc: cuda_fx@yahoo.com, marciom@conectiva.com.br, daveh@insightdist.com, pgsql-sql@postgreSQL.org, srswamy@giasdl01.vsnl.net.in In-Reply-To: <199809161730.NAA14401@candle.pha.pa.us> from "Bruce Momjian" at Sep 16, 98 01:30:47 pm X-Mailer: ELM [version 2.4 PL24] Content-Type: text According to Bruce Momjian: > > > 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 > > Actually, the FAQ mentions it, the psql \? command, and psql manual page > mention it. Is there somewhere else we should mention it? Is it documented which things work with which data types (text vs. varchar)? Les Mikesell les@mcs.com