Re: index with LIKE

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Henrik Steffen <steffen(at)topconcepts(dot)de>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: index with LIKE
Date: 2004-06-11 03:20:38
Message-ID: 40C92506.5010006@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout wrote:
> The classic issue is what encoding are the databases. Anything other
> than C and like won't use indexes.

Unless you use text_pattern_ops. See
http://www.postgresql.org/docs/7.4/static/indexes-opclass.html

I think this needs to be in the faq.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-11 08:02:36 Re: [GENERAL] out of memory error
Previous Message Mark Striebeck 2004-06-11 01:14:32 out of memory error