On 3/30/13 11:35 PM, Tom Lane wrote: > The LIKE index optimization is hard-wired into > match_special_index_operator(), which never heard of citext's ~~ > operators. > > I've wanted for years to replace that mechanism with something that > would support plug-in extensions, but have no very good idea how to > do it.
I have been thinking there should be a GiST index that associates with the pattern matching operators. I haven't worked out the details, but at least this seems it might be the right framework to solve this problem. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
