Re: [SQL] Functional Indexes

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: "PgSQL-sql" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] Functional Indexes
Date: 1999-02-08 18:36:39
Message-ID: 003101be5391$f74dffc0$a3f0f6ce@bryan.arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1999-02-08 20:49:57 RE: SQL Syntax
Previous Message Thomas G. Lockhart 1999-02-08 15:56:12 Re: [HACKERS] Re: [SQL] Functional Indexes