inverted_word_index
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
inverted_word_index [2011/04/09 20:50] – daniel | inverted_word_index [2011/08/09 16:57] – [Function] daniel | ||
---|---|---|---|
Line 9: | Line 9: | ||
The word index can be queried in SQL. Here is the code of a PL/pgSQL function that retrieves the IDs of messages containing a set of words. The words are given as an array of text. | The word index can be queried in SQL. Here is the code of a PL/pgSQL function that retrieves the IDs of messages containing a set of words. The words are given as an array of text. | ||
- | The function is already in the Manitou-Mail database for versions 1.0.3 and above | + | The function is already in the Manitou-Mail database for versions 1.1.0 and above |
<code sql> | <code sql> | ||
-- Input: an array of words to search within the entire index | -- Input: an array of words to search within the entire index |
inverted_word_index.txt · Last modified: 2016/05/16 12:27 by daniel