Postgres Pro
Downloads
Home   >   mailing lists

Re: indexing and LIKE - Mailing list pgsql-sql

From Allan Engelhardt
Subject Re: indexing and LIKE
Date
Msg-id 3BC5FF93.8E1A688A@cybaea.com
Whole thread Raw
In response to indexing and LIKE  (Patrik Kudo <kudo@partitur.se>)
List pgsql-sql
Tree view 
Patrik Kudo wrote:

> [...]
>
> Is it at all possible to create an index on lower(name), and in that case,
> what type of index and using what syntax?

You'll want to look at section 7.5 "Functional Indices" in the 7.1.3 'User's Guide'.

Allan.

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Server crash caused by CHECK on child
Next
From: Patrik Kudo
Date:
Subject: Re: indexing and LIKE