Postgres Pro Enterprise : Documentation: 10: Chapter 12. Full Text Search : Postgres Professional

Download:

epub
pdf

This page in other versions:
Postgres Pro Standard

11
10
9.6
9.5
( current )

Postgres Pro Enterprise

PostgreSQL

12
11
10
9.6
9.5
9.4

Chapter 12. Full Text Search
Prev	Up	Part II. The SQL Language	Home	Next

Chapter 12. Full Text Search

Table of Contents

12.1. Introduction

12.1.1. What Is a Document?
12.1.2. Basic Text Matching
12.1.3. Configurations

12.2. Tables and Indexes

12.2.1. Searching a Table
12.2.2. Creating Indexes

12.3. Controlling Text Search

12.3.1. Parsing Documents
12.3.2. Parsing Queries
12.3.3. Ranking Search Results
12.3.4. Highlighting Results

12.4. Additional Features

12.4.1. Manipulating Documents
12.4.2. Manipulating Queries
12.4.3. Triggers for Automatic Updates
12.4.4. Gathering Document Statistics

12.5. Parsers

12.6. Dictionaries

12.6.1. Stop Words
12.6.2. Simple Dictionary
12.6.3. Synonym Dictionary
12.6.4. Thesaurus Dictionary
12.6.5. Ispell Dictionary
12.6.6. Snowball Dictionary

12.7. Configuration Example

12.8. Testing and Debugging Text Search

12.8.1. Configuration Testing
12.8.2. Parser Testing
12.8.3. Dictionary Testing

12.9. GIN and GiST Index Types

12.10. psql Support

12.11. Limitations

Prev	Up	Next
11.13. Using k-NN Algorithm for Optimizing Queries	Home	12.1. Introduction