Postgres Pro
Downloads
Home   >   mailing lists

Re: Index use difference betweer LIKE, LIKE ANY? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Index use difference betweer LIKE, LIKE ANY?
Date
Msg-id 4D696CFE.2010107@agliodbs.com
Whole thread Raw
In response to Index use difference betweer LIKE, LIKE ANY?  ("Sam Wong" <sam@hellosam.net>)
Responses Re: Index use difference betweer LIKE, LIKE ANY?  (Chetan Suttraway <chetan.suttraway@enterprisedb.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Picking out the most recent row using a time stamp column
Next
From: Dave Johansen
Date:
Subject: Re: Picking out the most recent row using a time stamp column