Received: from flex.flex.ro (IDENT:root@[193.230.255.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id AAA78274
	for <pgsql-interfaces@postgresql.org>;
	Mon, 1 Nov 1999 00:45:16 -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 HAA31709;
	Mon, 1 Nov 1999 07:47:08 +0200
Sender: teo@flex.flex.ro
Message-ID: <381D36F1.72C6F912@flex.ro>
Date: Mon, 01 Nov 1999 08:45:05 +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: Wim Ceulemans <wim.ceulemans@nice.be>
CC: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
References: <381C31A8.34A17B8E@flex.ro> <381C6ECC.1A8992C3@nice.be>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Wim Ceulemans wrote:
> 
> The case insensitive equivalent in postgreSQL is:
> 
>         select ~* 'john'
> 

I know that, I'm using on PostgreSQL the regexp search but I would like
to unify also the SQL commands.

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA