Re: [SQL] Functional Indexes - Mailing list pgsql-sql

From Bryan White
Subject Re: [SQL] Functional Indexes
Date
Msg-id 003101be5391$f74dffc0$a3f0f6ce@bryan.arcamax.com
Whole thread Raw
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: [SQL] Functional Indexes
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: SQL Syntax