Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.8.8/8.8.8) with ESMTP id NAA00372 for ; Wed, 16 Sep 1998 13:33:15 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id NAA14401; Wed, 16 Sep 1998 13:30:47 -0400 (EDT) From: Bruce Momjian Message-Id: <199809161730.NAA14401@candle.pha.pa.us> Subject: Re: [SQL] How to Make Case InSensitive??? In-Reply-To: <19980916134810.21155.rocketmail@send101.yahoomail.com> from Barracuda at "Sep 16, 1998 6:48:10 am" To: cuda_fx@yahoo.com (Barracuda) Date: Wed, 16 Sep 1998 13:30:47 -0400 (EDT) Cc: marciom@conectiva.com.br, daveh@insightdist.com, pgsql-sql@postgreSQL.org, srswamy@giasdl01.vsnl.net.in X-Mailer: ELM [version 2.4ME+ PL43 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > 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? -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 http://www.op.net/~candle | (610) 353-9879(w) + If your life is a hard drive, | (610) 853-3000(h) + Christ can be your backup. |