Re: Index use difference betweer LIKE, LIKE ANY?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Sam Wong <sam(at)hellosam(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index use difference betweer LIKE, LIKE ANY?
Date: 2011-02-26 21:13:34
Message-ID: 4D696CFE.2010107@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 2/25/11 5:31 AM, Sam Wong wrote:
> I found that "LIKE", "= ANY (...)", "LIKE .. OR LIKE .." against a text
> field used the index correctly, but not "LIKE ANY (...)". Would that be a
> bug?

No, it would be a TODO. This is a known limitation; it needs some
clever code to make it work, and nobody's written it.

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Johansen 2011-02-26 21:38:05 Re: Picking out the most recent row using a time stamp column
Previous Message Josh Berkus 2011-02-26 21:06:00 Re: Picking out the most recent row using a time stamp column