Received: from chekov.Belgium.EU.net (chekov.belgium.eu.net [193.74.208.161])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA81916
	for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 11:28:52 -0500 (EST)
	(envelope-from wim.ceulemans@nice.be)
Received: from (IDENT:0@idialup508.brussels2.eunet.be [193.75.159.253])
	by chekov.Belgium.EU.net  with ESMTP id RAA18258;
	Sun, 31 Oct 1999 17:28:41 +0100 (MET)
Received: from nice.be (aladdin.nice.be [192.168.250.110])
	by uni-box.nice.be (8.9.1/8.9.1) with ESMTP id RAA03037;
	Sun, 31 Oct 1999 17:28:14 +0100
Message-ID: <381C6ECC.1A8992C3@nice.be>
Date: Sun, 31 Oct 1999 17:31:08 +0100
From: Wim Ceulemans <wim.ceulemans@nice.be>
X-Mailer: Mozilla 4.61 [en] (Win95; I)
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

The case insensitive equivalent in postgreSQL is:

	select ~* 'john'

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 ?
> 
> TIA,
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA
> 
> ************

-- 
Wim Ceulemans
Nice bvba www.nice.be
Eglegemweg 3, 2811 Hombeek Belgium
Tel 0032-15-412953 Fax 0032-15-412954