Умный поиск¶
CREATE EXTENSION fuzzystrmatch;
select * from (select levenshtein('ручку', title,0,1,1) a,title,length(title) l from skk_good sg) a
where a.a<2
order by 1
CREATE EXTENSION fuzzystrmatch;
select * from (select levenshtein('ручку', title,0,1,1) a,title,length(title) l from skk_good sg) a
where a.a<2
order by 1