BUG #1237: text_field like 'abc%' not using index on text_field

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1237: text_field like 'abc%' not using index on text_field
Date: 2004-08-31 14:50:03
Message-ID: 20040831145003.1B9EB5A10EC@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1237
Logged by: Chris Dipple

Email address: chris(at)secpay(dot)com

PostgreSQL version: 7.4.3

Operating system: Linux

Description: text_field like 'abc%' not using index on text_field

Details:

Upgraded from 7.2 to 7.4.5. Old queries now do not use index that were used
before. See short decription.

Browse pgsql-bugs by date

  From Date Subject
Next Message Fabien COELHO 2004-08-31 15:07:31 ALTER INDEX broken in CVS head?
Previous Message Robert Creager 2004-08-31 02:19:17 Re: Error: could not find a feasible split point for