Received: from hu.tm.ee (isdn-54.uninet.ee [194.204.0.118])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA48655
	for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 06:25:46 -0500 (EST) (envelope-from hannu@tm.ee)
Received: from tm.ee (localhost [127.0.0.1]) by hu.tm.ee (Postfix) with ESMTP
	id 7D6273C2B; Sun, 31 Oct 1999 14:35:48 +0200 (EET)
Sender: hannu@hu.tm.ee
Message-ID: <381C37A3.EC9D5D4D@tm.ee>
Date: Sun, 31 Oct 1999 12:35:47 +0000
From: Hannu Krosing <hannu@tm.ee>
Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?=
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.13-7mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Constantin Teodorescu <teo@flex.ro>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
References: <381C31A8.34A17B8E@flex.ro>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Constantin Teodorescu wrote:
> 
> I'm writing an application that should work with PostgreSQL server on
> Linux and ODBC-MS Access on Windows.
> 
> I'm using the TclODBC package that works just fine.
> 
> Under Windows, with ODBC->MS Access , the select LIKE 'john%' works case
> insensitive!
> Under Linux with PostgreSQL 6.5.2 , the LIKE clause is case sensitive!
> 
> Is there for PostgreSQL a modifier(parameter) that will make the LIKE
> clause case insensitive ?

Maybe

 select * from t where lower(name) like 'john%';

------------
Hannu