Received: from flex.flex.ro (IDENT:root@[193.230.255.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA46918
	for <pgsql-interfaces@postgresql.org>;
	Sun, 31 Oct 1999 06:10:23 -0500 (EST) (envelope-from teo@flex.ro)
Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3])
	by flex.flex.ro (8.9.3/8.9.3) with ESMTP id NAA00939
	for <pgsql-interfaces@postgresql.org>; Sun, 31 Oct 1999 13:12:21 +0200
Sender: teo@flex.flex.ro
Message-ID: <381C31A8.34A17B8E@flex.ro>
Date: Sun, 31 Oct 1999 14:10:16 +0200
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting Braila
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Case insensitive LIKE ?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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