Received: from druid.net (root@druid.net [216.126.72.98])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA60416
	for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 08:30:08 -0500 (EST) (envelope-from darcy@druid.net)
Received: from localhost (1219 bytes) by druid.net
	via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp
	(sender: <darcy>) (ident <darcy> using unix)
	id <m11hv3P-0000bFC@druid.net> for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 08:29:51 -0500 (EST)
	(Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13)
Message-Id: <m11hv3P-0000bFC@druid.net>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
In-Reply-To: <381C3665.572E14EF@flex.ro> from Constantin Teodorescu at "Oct
 31,
	1999 02:30:29 pm"
To: teo@flex.ro (Constantin Teodorescu)
Date: Sun, 31 Oct 1999 08:29:51 -0500 (EST)
From: "D'Arcy" "J.M." Cain <darcy@druid.net>
Cc: hannu@tm.ee, pgsql-interfaces@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL50 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Thus spake Constantin Teodorescu
> Hannu Krosing wrote:
> >  select * from t where lower(name) like 'john%';
> Yes, it may work, but probably lower(name) won't work on ODBC->MS Access

Don't know about the M$ issue but if you do use the above you may want to
do the following to speed things up.

CREATE INDEX lower_name ON t (LOWER(name) text_ops);

A simple index on name won't help in the above query.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.