> On 11 Mar 2015, at 10:54pm, Milan Roubal <roubal at keyserver.cz> wrote:
>
> .load ./libstringmetrics.so
> select a.firstname, b.firstname, a.lastname, b.lastname,
> stringmetrics("qgrams_distance","similarity",a.firstname, b.firstname,"")
> first_dist,
> stringmetrics("qgrams_distance","similarity",a.lastname, b.lastname,"")
> last_dist
> from
> (select "Milan" as firstname, "Roubal" as lastname ) a,
> (select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b
Do any of these crash ?
SELECT stringmetrics("qgrams_distance","similarity","Milan", "Milan","");
SELECT stringmetrics("qgrams_distance","similarity","Roubal",
"RoubalRoubalRoubalRo","");
select stringmetrics("qgrams_distance","similarity",a.firstname,
b.firstname,"") first_dist
from
(select "Milan" as firstname, "Roubal" as lastname ) a,
(select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b;
select stringmetrics("qgrams_distance","similarity",a.lastname, b.lastname,"")
last_dist
from
(select "Milan" as firstname, "Roubal" as lastname ) a,
(select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b;
?
