Received: from arcamax.com (arcamax.com [206.246.240.138])
	by hub.org (8.9.2/8.9.1) with ESMTP id NAA50869
	for <pgsql-sql@postgreSQL.org>; Mon, 8 Feb 1999 13:36:57 -0500 (EST)
	(envelope-from bryan@arcamax.com)
Received: from bryan.arcamax.com (bryan [206.246.240.163])
	by arcamax.com (8.8.7/8.8.7) with SMTP id NAA16322
	for <pgsql-sql@postgreSQL.org>; Mon, 8 Feb 1999 13:36:40 -0500
Message-ID: <003101be5391$f74dffc0$a3f0f6ce@bryan.arcamax.com>
From: "Bryan White" <bryan@arcamax.com>
To: "PgSQL-sql" <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] Functional Indexes
Date: Mon, 8 Feb 1999 13:36:39 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

OK, I have used the correct incantation to create the index and that works.

I don't see how to use this index in a select.  I guess I need an operator
that is case-insensitive but does not use regular expressions.  There does
not seem to be one listed in the Manual.