1

(1 row)

select similarity('---', '####---');

similarity

------------

0

(1 row)

CREATE TABLE test_trgm(t text);

\copy test_trgm from 'data/trgm.data

select t,similarity(t,'qwertyu0988') as sml from test_trgm where t % 'qwertyu0988' order by sml desc, t;

select similarity('wow','WOWa');

select similarity('wow',' WOW');

select similarity('---','####---');

CREATETABLEtest_trgm(ttext);

\copy test_trgmfrom'data/trgm.data

len1=ARRNELEM(trg1);

len2=ARRNELEM(trg2);

if (len1 <=0||len2 <=0)

return (float4)0.0;

while (ptr1-GETARR(trg1)<len1&&ptr2-GETARR(trg2)<len2)

{

intres=CMPTRGM(ptr1,ptr2);

}

return ((((float4)count) / ((float4) (len1+len2-count))));

return ((float4)count) / ((float4) (len1+len2-count));

return (((float)count) / ((float) ((len1>len2) ?len1 :len2)));

return ((float4)count) / ((float4) ((len1>len2) ?len1 :len2));

}