On Mar 20, 2013, at 1:45 AM, David E. Wheeler <da...@kineticode.com> wrote:
>> Is there currently any way to create an index that can be used to speed up >> searches like the one above? >> If not, do you have any idea how it might be implemented? Perhaps I could >> give it a try myself. >> >> Thank you in advance for any suggestions you might have. > > I would think that text_pattern_ops would work, no? Thorbjørn replied to me privately in the negative. Hackers, what would be required to get an index on a CITEXT column to support LIKE? Thanks, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers