Received: from email03.aon.at (WARSL401PIP5.highway.telekom.at [195.3.96.112])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f44LtLA73763
	for <pgsql-admin@postgresql.org>; Fri, 4 May 2001 17:55:21 -0400 (EDT)
	(envelope-from vecernik@aon.at)
Received: (qmail 2535024 invoked from network); 4 May 2001 21:55:17 -0000
Received: from m214p017.dipool.highway.telekom.at (HELO aon.at)
	([62.46.16.177]) (envelope-sender <vecernik@aon.at>)
	by qmail3.highway.telekom.at (qmail-ldap-1.03) with SMTP
	for <tsattler@speakeasy.net>; 4 May 2001 21:55:17 -0000
Message-ID: <3AF323E2.CBD5ED27@aon.at>
Date: Fri, 04 May 2001 23:49:22 +0200
From: Oliver Vecernik <vecernik@aon.at>
Organization: VECERNIK Datenerfassungssysteme
X-Mailer: Mozilla 4.76 [de] (X11; U; Linux 2.4.0-4GB i686)
X-Accept-Language: de-AT, en
MIME-Version: 1.0
To: tsattler@speakeasy.net
CC: pgsql-admin@postgresql.org
Subject: Re: Queries
References: <200105041512.IAA22056@webmail.speakeasy.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200105/23
X-Sequence-Number: 1363

tsattler@speakeasy.net wrote:
> 
> Greetings All.
> 
> I have a record on my database with a last name of 'DeFelice'.
> 
> I want to be able to retrieve that record whether a user enters 'DeFelice', 'Defelice', 'defelice', or 'DEFELICE'.  Is there a way I can do that?  Is that what the "ilike" function does?
> 
> I'm on 7.0.3.

~* Match (regex), case insensitive is what you are looking for.

Regards,
Oliver