• Login / Register
  • My Account
  • News & Events
  • Blog
  • Downloads
  • Forums
  • Store
  • Customer Portal
  • Contact Us

Search our site

  • Why EnterpriseDB?
  • Products, Services & Training
  • Solutions
  • Customer Success
  • Resources & Community
  • Partner Programs
  • About Us

How EnterpriseDB Works For You

IT Managers
Leverage existing skills, deploy new apps, and reduce overall infrastructure costs.

Learn more

Database Administrators
Ensure your database is scalable, available, secure and easy to use.

Learn more

Developers
Deliver complex applications faster and cheaper than before.

Learn more

Architects
Establish a proven database infrastructure for now and the future.

Learn more

Oracle Costs Eating
Up Your Budget?

Learn How Postgres Can
Rein in Oracle Costs

Get Started Today!
Tools for evaluations & pilots,
through deployment and into production

Products & Tools
Postgres Plus Advanced Server
Postgres Plus Standard Server
PostgreSQL Server
Compare All 3 Servers...
Postgres Plus Tools
Documentation
Downloads

Technical Services
Technical Support
Packaged Services
Oracle Migration Assessment
MySQL Migration Assessment
Professional Consulting
 

Call Technical Support:
Call: +1-732-331-1320 or
1-800-235-5891 (US Only)

PostgreSQL Subscriptions
Basic Subscription
Premium Subscription
Jumpstart Subscription
Developer Subscription
All Subscriptions
Unlimited Subscription

Questions About Our
Products or Services?
Call: +1 781-357-3390
or click here to Write us...

PostgreSQL Training
DBA Schedule
Developer Schedule

PostgreSQL Certification
Associate
Professional

Getting Started
Oracle Compatibility
Postgres Performance Management
MySQL vs PostgreSQL
Postgres Plus Virtual Appliances
Postgres Plus Cloud Computing

Customers
Customer Spotlight
By Application Type/Workload

Resources
Tutorials and Quick Starts
On-Demand Webcasts
Videos
Podcasts
White Papers
Data Sheets

Community
Community Projects
EnterpriseDB Contributions
Community Contributors
Blogs
EnterpriseDB Forums

Partner Home
Embedded & Bundled Database (OEM/ISV)
Distributors & Resellers
Hosting & Saas Providers
Systems Integrators
Strategic Technology Providers
Certified Application Vendors
Government Partners & Federal Certifications
Become a Partner
Partner Resources

Executive Team
Board Of Directors
Awards and Recognition
Careers
Office Locations
Contact Us


PostgreSQL 8.3.10 Documentation
PrevFast BackwardFast ForwardNext

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. GiST and GIN Index Types
12.10. psql Support
12.11. Limitations
12.12. Migration from Pre-8.3 Text Search

PrevHomeNext
Examining Index UsageUpIntroduction

Copyright © 2011 EnterpriseDB Corporation. All rights reserved.

  • Follow us on Twitter
  • Read the Blog
  • Site Feedback
  • Follow on Facebook
  • Privacy Policy