Re: indexing and LIKE

From: Allan Engelhardt <allane(at)cybaea(dot)com>
To: Patrik Kudo <kudo(at)partitur(dot)se>
Subject: Re: indexing and LIKE
Date: 2001-10-11 20:22:43
Message-ID: 3BC5FF93.8E1A688A@cybaea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Orion 2001-10-11 20:31:59 count(*) and limit
Previous Message Ross J. Reedstrom 2001-10-11 20:05:26 Re: indexing and LIKE