LIKE and indexes?

From: Alexander Jerusalem <alexander(dot)jerusalem(at)pop(dot)chello(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: LIKE and indexes?
Date: 2001-03-14 22:25:26
Message-ID: 4.3.2.7.0.20010314232310.00cc3be0@pop.runbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message keith 2001-03-14 22:35:22 Fw: Fw: Please Help
Previous Message Roy Souther 2001-03-14 22:24:12 Can I make direct calls to PostgreSQL server?