Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from rainbow-jr.dreaming.org (rainbow-jr.dreaming.org [199.166.238.138]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id WAA18026 for <postgres95@nobozo.cs.berkeley.edu>; Tue, 31 Oct 1995 22:38:06 -0800
Received: (from scrappy@localhost) by rainbow-jr.dreaming.org (8.6.9/8.6.9) id CAA02085; Wed, 1 Nov 1995 02:35:28 -0500
Date: Wed, 1 Nov 1995 02:35:20 -0500 (EST)
From: "Marc G. Fournier" <scrappy@rainbow-jr.dreaming.org>
To: rp2y+@CS.cmu.edu
cc: postgres95@postgres.Berkeley.EDU
Subject: Re: Quick question about case-insensitive select...like 
In-Reply-To: <199511010420.XAA01231@mail.dreaming.org>
Message-ID: <Pine.BSF.3.91.951101022853.2018B-100000@rainbow-jr.dreaming.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres95-redist
Resent-Date: Tue, 31 Oct 95 22:38:15 -0800
Resent-From: pglite
Resent-XMts: smtp

On Tue, 31 Oct 1995, Robert Patrick wrote:

> > 
> > 	Would I be safe in assuming that within my C code, if I
> > converted the search string all to lowercase before issuing the
> > select, I would be fine?  Or is it a step I don't need, for
> > I'm just calling it wrong?
> 
> The LIKE operator *IS* case-sensitive!  Do not assume otherwise.  If you don't 
> believe me, look at the code (i.e., the DoMatch() function in 
> src/backend/utils/adt/like.c)
>

Checked the code, and there is no doubt, but...

Ack, I feel ... well, not stupid, just highly unobservant...

The string that it kept coming up with had two occurances of the 
substring in it, one that was '%Art%', and one that was '%art%'...
the first was the first word in the title, the second was a 
substring of 'heart' :(

Sorry for wasting time on that one...


===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========
