|
|
DBsight 1.5.5 (Bundled with App Server branch)
05-12-2008
DBSight is a J2EE search platform for instant scalable full-text search on any relational database, for both beginners and experts. It features a built-in database crawler following user-defined SQL, incremental indexing, user-controllable result ranking, the ability to return results with highlights (like Google), and categorized result counts (like Amazon). It can easily integrate with other languages with XML/JSON/HTML. There is a UI for all operations, so no Java coding is necessary. Deleted or updated records in database can be synchronized also. License: Free for non-commercial use Changes:|
|
CREATE TEXT SEARCH
CONFIGURATION(7) SQL Commands CREATE TEXT SEARCH CONFIGURATION(7) NAME
CREATE TEXT SEARCH CONFIGURATION - define a new text search configuration SYNOPSIS
CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config ) DESCRIPTION
CREATE TEXT SEARCH CONFIGURATION creates a new text search configuration. A text search configuration specifies a text search parser that can divide a string into tokens, plus dictionaries that can be used to determine which tokens are of interest for searching. If only the parser is specified, then the new text search configuration initially has no mappings from token types to dictionaries, and therefore will ignore all words. Subsequent ALTER TEXT SEARCH CONFIGURATION commands must be used to create mappings to make the configura- tion useful. Alternatively, an existing text search configuration can be copied. If a schema name is given then the text search configuration is created in the specified schema. Otherwise it is created in the current schema. The user who defines a text search configuration becomes its owner. Refer to in the documentation for further information. PARAMETERS
name The name of the text search configuration to be created. The name can be schema-qualified. parser_name The name of the text search parser to use for this configuration. source_config The name of an existing text search configuration to copy. NOTES
The PARSER and COPY options are mutually exclusive, because when an existing configuration is copied, its parser selection is copied too. COMPATIBILITY
There is no CREATE TEXT SEARCH CONFIGURATION statement in the SQL standard. SEE ALSO
ALTER TEXT SEARCH CONFIGURATION [alter_text_search_configuration(7)], DROP TEXT SEARCH CONFIGURATION [drop_text_search_configuration(7)] SQL - Language Statements 2010-05-14 CREATE TEXT SEARCH CONFIGURATION(7)