On 2014-11-20 12:00:51 -0800, Peter Geoghegan wrote: > In more concrete terms, this gets no suggestion: > > postgres=# select key from pg_index; > ERROR: 42703: column "key" does not exist > LINE 1: select key from pg_index; > ^
I don't think that's a bad thing. Yes, for a human those look pretty similar, but it's easy to construct cases where that gives completely hilarious results. I think something simplistic like levenshtein, even with modified distances, is good to catch typos. But not to find terms that are related in more complex ways. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers