OBJS = trgm_op.o trgm_gist.o trgm_gin.o trgm_regexp.o$(WIN32RES)

EXTENSION = pg_trgm

DATA = pg_trgm--1.3.sql pg_trgm--1.0--1.1.sql pg_trgm--1.1--1.2.sql pg_trgm--1.2--1.3.sql pg_trgm--unpackaged--1.0.sql

DATA = pg_trgm--1.2.sql pg_trgm--1.0--1.1.sql pg_trgm--1.1--1.2.sql pg_trgm--unpackaged--1.0.sql

PGFILEDESC = "pg_trgm - trigram matching"

REGRESS = pg_trgm pg_substring_trgm

Tombankala | 0.6

(17 rows)

select set_substring_limit(0.5);

set_substring_limit

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

0.5

(1 row)

set "pg_trgm.substring_limit" to 0.5;

select t,substring_similarity('Baykal',t) as sml from test_trgm2 where 'Baykal' <% t order by sml desc, t;

t | sml

-------------------------------------+----------

Rokba Kala Sardoun | 0.5

(25 rows)

select set_substring_limit(0.3);

set_substring_limit

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

0.3

(1 row)

set "pg_trgm.substring_limit" to 0.3;

select t,substring_similarity('Baykal',t) as sml from test_trgm2 where 'Baykal' <% t order by sml desc, t;

t | sml

-----------------------------------------------------------+----------

\echo Use"ALTER EXTENSION pg_trgm UPDATE TO '1.2'" to load this file. \quit

CREATEFUNCTIONsubstring_similarity(text,text)

RETURNS float4

LANGUAGE C STRICT IMMUTABLE;

CREATEFUNCTIONsubstring_similarity_op(text,text)

RETURNS bool

LANGUAGE C STRICT STABLE;-- stable because depends on trgm_substring_limit

CREATEFUNCTIONsubstring_similarity_commutator_op(text,text)

RETURNS bool

LANGUAGE C STRICT STABLE;-- stable because depends on trgm_substring_limit

CREATE OPERATOR<% (

LEFTARG=text,

RIGHTARG=text,

PROCEDURE= substring_similarity_op,

COMMUTATOR='%>',

RESTRICT= contsel,

JOIN= contjoinsel

);

CREATE OPERATOR %> (

LEFTARG=text,

RIGHTARG=text,

PROCEDURE= substring_similarity_commutator_op,

COMMUTATOR='<%',

RESTRICT= contsel,

JOIN= contjoinsel

);

CREATEFUNCTIONgin_trgm_triconsistent(internal, int2,text, int4, internal, internal, internal)

RETURNS"char"

LANGUAGE C IMMUTABLE STRICT;

ALTEROPERATOR FAMILY gist_trgm_ops USING gist ADD

OPERATOR7 %> (text,text);

ALTEROPERATOR FAMILY gin_trgm_ops USING gin ADD

FUNCTION6 (text,text) gin_trgm_triconsistent (internal, int2,text, int4, internal, internal, internal);

OPERATOR7 %> (text,text),

FUNCTION6 (text,text) gin_trgm_triconsistent (internal, int2,text, int4, internal, internal, internal);

\echo Use"CREATE EXTENSION pg_trgm" to load this file. \quit

CREATEFUNCTIONset_limit(float4)

RETURNS float4

LANGUAGE C STRICT VOLATILE;

CREATEFUNCTIONshow_limit()

RETURNS float4

CREATEFUNCTIONsimilarity_op(text,text)

RETURNS bool

LANGUAGE C STRICT STABLE;-- stable because depends ontrgm_limit

LANGUAGE C STRICT STABLE;-- stable because depends onpg_trgm.limit

CREATE OPERATOR % (

LEFTARG=text,

JOIN= contjoinsel

);

CREATEFUNCTIONset_substring_limit(float4)

RETURNS float4

LANGUAGE C STRICT VOLATILE;

CREATEFUNCTIONshow_substring_limit()

RETURNS float4

LANGUAGE C STRICT STABLE;

CREATEFUNCTIONsubstring_similarity(text,text)

RETURNS float4

CREATEFUNCTIONsubstring_similarity_op(text,text)

RETURNS bool

LANGUAGE C STRICT STABLE;-- stable because depends ontrgm_substring_limit

LANGUAGE C STRICT STABLE;-- stable because depends onpg_trgm.substring_limit

CREATEFUNCTIONsubstring_similarity_commutator_op(text,text)

RETURNS bool

LANGUAGE C STRICT STABLE;-- stable because depends ontrgm_substring_limit

LANGUAGE C STRICT STABLE;-- stable because depends onpg_trgm.substring_limit

CREATE OPERATOR<% (

LEFTARG=text,

ALTEROPERATOR FAMILY gist_trgm_ops USING gist ADD

OPERATOR5 pg_catalog.~ (text,text),

OPERATOR6 pg_catalog.~* (text,text);

ALTEROPERATOR FAMILY gist_trgm_ops USING gist ADD

OPERATOR6 pg_catalog.~* (text,text),

OPERATOR7 %> (text,text);

LANGUAGE C IMMUTABLE STRICT;

ALTEROPERATOR FAMILY gin_trgm_ops USING gin ADD

FUNCTION6 (text,text) gin_trgm_triconsistent (internal, int2,text, int4, internal, internal, internal);

ALTEROPERATOR FAMILY gin_trgm_ops USING gin ADD

OPERATOR7 %> (text,text);

OPERATOR7 %> (text,text),

FUNCTION6 (text,text) gin_trgm_triconsistent (internal, int2,text, int4, internal, internal, internal);

# pg_trgm extension

comment = 'text similarity measurement and index searching based on trigrams'

default_version = '1.3'

default_version = '1.2'

module_pathname = '$libdir/pg_trgm'

relocatable = true

select t,substring_similarity('Baykal',t)as smlfrom test_trgm2where t %>'Baykal'order by smldesc, t;

select t,substring_similarity('Kabankala',t)as smlfrom test_trgm2where t %>'Kabankala'order by smldesc, t;

select set_substring_limit(0.5);

set"pg_trgm.substring_limit" to0.5;

select t,substring_similarity('Baykal',t)as smlfrom test_trgm2where'Baykal'<% torder by smldesc, t;

select t,substring_similarity('Kabankala',t)as smlfrom test_trgm2where'Kabankala'<% torder by smldesc, t;

select t,substring_similarity('Baykal',t)as smlfrom test_trgm2where t %>'Baykal'order by smldesc, t;

select t,substring_similarity('Kabankala',t)as smlfrom test_trgm2where t %>'Kabankala'order by smldesc, t;

select set_substring_limit(0.3);

set"pg_trgm.substring_limit" to0.3;

select t,substring_similarity('Baykal',t)as smlfrom test_trgm2where'Baykal'<% torder by smldesc, t;

select t,substring_similarity('Kabankala',t)as smlfrom test_trgm2where'Kabankala'<% torder by smldesc, t;

select t,substring_similarity('Baykal',t)as smlfrom test_trgm2where t %>'Baykal'order by smldesc, t;

#defineGETARR(x)( (trgm*)( (char*)x+TRGMHDRSIZE ) )

#defineARRNELEM(x) ( ( VARSIZE(x) - TRGMHDRSIZE )/sizeof(trgm) )

#defineCALCSML(count,len1,len2) ((float4) (count)) / ((float4) ((len1) + (len2) - (count)))

typedefstructTrgmPackedGraphTrgmPackedGraph;

externfloat4trgm_limit;

externfloat4trgm_substring_limit;

externdoubletrgm_limit;

externdoubletrgm_substring_limit;

externuint32trgm2int(trgm*ptr);

externvoidcompact_trigram(trgm*tptr,char*str,intbytelen);

TrgmPackedGraph**graph,MemoryContextrcontext);

externbooltrigramsMatchGraph(TrgmPackedGraph*graph,bool*check);

res= (nkeys==0) ? false : ((((((float4)ntrue) / ((float4)nkeys))) >=trgm_limit) ? true : false);

res= (nkeys==0) ? false : (((((float4)ntrue) / ((float4)nkeys))) >=trgm_limit);

break;

caseILikeStrategyNumber:

Assert(res!=GIN_TRUE);

PG_RETURN_GIN_TERNARY_VALUE(res);

}

}

boolres;

Sizequerysize=VARSIZE(query);

gtrgm_consistent_cache*cache;

float4nlimit;

doublenlimit;

caseSimilarityStrategyNumber:

caseSubstringSimilarityStrategyNumber:

*recheck= (strategy==SubstringSimilarityStrategyNumber) ? true : false;

*recheck= (strategy==SubstringSimilarityStrategyNumber);

nlimit= (strategy==SimilarityStrategyNumber) ?trgm_limit :trgm_substring_limit;

if (GIST_LEAF(entry))

{/* all leafs contains orig trgm */

float4tmpsml=cnt_sml(qtrg,key,*recheck);

res= (*(int*)&tmpsml==*(int*)&nlimit||tmpsml>nlimit) ? true : false;

res= (*(int*)&tmpsml==*(int*)&nlimit||tmpsml>nlimit);

}

elseif (ISALLTRUE(key))

{/* non-leaf contains signature */

if (len==0)

res= false;

res= (((((float8)count) / ((float8)len))) >=nlimit) ? true : false;

res= (((((float8)count) / ((float8)len))) >=nlimit);

}

break;

caseILikeStrategyNumber:

v->spl_rdatum=PointerGetDatum(datum_r);

PG_RETURN_POINTER(v);

}

}