Postgres Pro
Downloads
Home   >   mailing lists

LIKE and indexes? - Mailing list pgsql-general

From Alexander Jerusalem
Subject LIKE and indexes?
Date
Msg-id 4.3.2.7.0.20010314232310.00cc3be0@pop.runbox.com
Whole thread Raw
Responses Re: LIKE and indexes?
List pgsql-general
Tree view 
Hi,

Can anyone telle me if and when a LIKE query uses an index? I've compiled
postgres with locale support. Does that have any influence indexes?

thanks,

Alexander Jerusalem

pgsql-general by date:

Previous
From: Roy Souther
Date:
Subject: Can I make direct calls to PostgreSQL server?
Next
From: Tom Lane
Date:
Subject: Re: Can I make direct calls to PostgreSQL server?