On Fri, Jun 3, 2016 at 12:13 PM, Greg Navis <cont...@gregnavis.com> wrote: > Thanks for answers and sorry for not searching hard enough. > > I'm curious ... would it be difficult to modify PostgreSQL so that it'd use > the index for `similarity(lhs, rhs) >= show_limit()` too?
Yes, that would be very difficult. The project has kind of painted itself into a corner on that. If it were easy, I doubt we would have added the % operator with the ugly set_limit() wart in the first place (although I was not around at the time that was done--maybe there were other considerations). Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
