Re: Problem with text_pattern_ops

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with text_pattern_ops
Date: 2005-07-26 22:39:56
Message-ID: 20050726153834.Y61081@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 26 Jul 2005, Joseph Shraibman wrote:

> I have this index:
>
> "directory_lower_username_seg_key" unique, btree (lower(username)
> text_pattern_ops, seg)
>
> ... but my query refuses to use that index.

text_pattern_ops is an opclass for doing LIKE queries using the index, I
don't believe it's used for equality comparisons.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2005-07-26 22:42:51 Re: Problem with text_pattern_ops
Previous Message Jim C. Nasby 2005-07-26 22:26:10 Re: ENUM type