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/08/09 16:57] – [Function] daniel | inverted_word_index [2012/05/29 00:13] – [Function] daniel | ||
---|---|---|---|
Line 10: | Line 10: | ||
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.1.0 and above | The function is already in the Manitou-Mail database for versions 1.1.0 and above | ||
- | <code sql> | + | <file sql wordsearch.sql> |
-- Input: an array of words to search within the entire index | -- Input: an array of words to search within the entire index | ||
-- Output: the mail_id of the matching messages, as a set. | -- Output: the mail_id of the matching messages, as a set. | ||
Line 73: | Line 73: | ||
$$ LANGUAGE plpgsql; | $$ LANGUAGE plpgsql; | ||
- | </code> | + | </file> |
===== Notes ===== | ===== Notes ===== | ||
The following formula: < | The following formula: < |
inverted_word_index.txt · Last modified: 2016/05/16 12:27 by daniel