OnDoc
| sign
in
up
~
pub
|
pdf
txt
html
toc
url
|
<<
>>
1
2
3
4
5
6
7
8
~
77
Table of Contents
FullText Search in PostgreSQL
Table of Contents
Chapter 1. FTS Introduction
1.1. Full Text Search in databases
1.1.1. What is a document?
1.2. FTS Overview
1.2.1. Tsquery and tsvector
1.2.2. FTS operator
1.3. Basic operations
1.3.1. Obtaining tsvector
1.3.2. Obtaining tsquery
1.3.3. Ranking search results
1.3.4. Getting results
1.3.5. Dictionaries
1.3.6. Stop words
1.4. FTS features
1.5. FTS Limitations
1.6. A Brief History of FTS in PostgreSQL
1.6.1. Pretsearch
1.6.2. Tsearch v1
1.6.3. Tsearch v2
1.6.4. FTS current
1.7. Links
1.8. FTS Todo
1.9. Acknowledgements
Chapter 2. FTS Operators and Functions
2.1. FTS operator
2.2. Vector Operations
2.3. Query Operations
2.3.1. Query rewriting
2.3.2. Operators for tsquery
2.3.3. Index for tsquery
2.4. Parser functions
2.5. Ranking
2.6. Headline
2.7. Fulltext indexes
2.8. Dictionaries
2.8.1. Simple dictionary
2.8.2. Ispell dictionary
2.8.3. Snowball stemming dictionary
2.8.4. Synonym dictionary
2.8.5. Thesaurus dictionary
2.8.5.1. Thesaurus configuration
2.8.5.2. Thesaurus examples
2.9. FTS Configuration
2.10. Debugging
2.11. Psql support
I. FTS Reference
I. SQL Commands
CREATE FULLTEXT CONFIGURATION
Name
Synopsis
Description
Parameters
Examples
See Also
DROP FULLTEXT CONFIGURATION
Name
Synopsis
Description
Parameters
See Also
ALTER FULLTEXT CONFIGURATION
Name
Synopsis
Description
Parameters
Examples
See Also
CREATE FULLTEXT DICTIONARY
Name
Synopsis
Description
Parameters
Examples
See Also
DROP FULLTEXT DICTIONARY
Name
Synopsis
Description
Parameters
See Also
ALTER FULLTEXT DICTIONARY
Name
Synopsis
Description
Parameters
See Also
CREATE FULLTEXT MAPPING
Name
Synopsis
Description
Parameters
Examples
See Also
ALTER FULLTEXT MAPPING
Name
Synopsis
Description
Parameters
Examples
See Also
DROP FULLTEXT MAPPING
Name
Synopsis
Description
Parameters
See Also
CREATE FULLTEXT PARSER
Name
Synopsis
Description
Parameters
See Also
DROP FULLTEXT PARSER
Name
Synopsis
Description
Parameters
See Also
ALTER FULLTEXT PARSER
Name
Synopsis
Description
Parameters
See Also
ALTER FULLTEXT ... OWNER
Name
Synopsis
Description
Parameters
Examples
COMMENT ON FULLTEXT
Name
Synopsis
Description
Parameters
Examples
II. Appendixes
Appendix A. FTS Complete Tutorial
Appendix B. FTS Parser Example
B.1. Parser sources
Appendix C. FTS Dictionary Example
Index
Symbols
A
B
C
D
F
H
I
L
N
P
Q
R
S
T