Commit0de96f8

committed

Update fti README and stopwords.

1 parent39282da commit0de96f8Copy full SHA for 0de96f8

File tree

-0

lines changed

-0

lines changed

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -27,6 +27,9 @@ the fti-table and the orig-table, we can get the actual rows we want`
`27`	`27`	`(this can also be done by using subselects, and maybe there're other`
`28`	`28`	`ways too).`
`29`	`29`
	`30`	`+The trigger code also allows an array called StopWords, that prevents`
	`31`	`+certain words from being indexed.`
	`32`	`+`
`30`	`33`	`As an example we take the previous query, where we assume we have all`
`31`	`34`	`sub-strings in the table 'cds-fti':`
`32`	`35`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -70,9 +70,11 @@ bool new_tuple = false;`
`70`	`70`
`71`	`71`	`/* THIS LIST MUST BE IN SORTED ORDER, A BINARY SEARCH IS USED!!!! */`
`72`	`72`	`charStopWords[]= {/ list of words to skip in indexing */`
	`73`	`+#ifdefSAMPLE_STOP_WORDS`
`73`	`74`	`"no"`
`74`	`75`	`"the",`
`75`	`76`	`"yes",`
	`77`	`+#endif`
`76`	`78`	`};`
`77`	`79`
`78`	`80`	`/* stuff for caching query-plans, stolen from contrib/spi/\.c /`
`@@ -331,6 +333,9 @@ is_stopword(char *text)`
`331`	`333`	`StopLow=&StopWords[0];/* initialize stuff for binary search */`
`332`	`334`	`StopHigh=endof(StopWords);`
`333`	`335`
	`336`	`+if (lengthof(StopWords)==0)`
	`337`	`+return false;`
	`338`	`+`
`334`	`339`	`while (StopLow <=StopHigh)`
`335`	`340`	`{`
`336`	`341`	`StopMiddle=StopLow+ (StopHigh-StopLow) /2;`

Comments

(0)