CREATE TEXT SEARCH DICTIONARY() SQL Commands CREATE TEXT SEARCH DICTIONARY()
NAME
CREATE TEXT SEARCH DICTIONARY - define a new text search dictionary
SYNOPSIS
CREATE TEXT SEARCH DICTIONARY name (
TEMPLATE = template
[, option = value [, ... ]]
)
DESCRIPTION
CREATE TEXT SEARCH DICTIONARY creates a new text search dictionary. A text search
dictionary specifies a way of recognizing interesting or uninteresting words for
searching. A dictionary depends on a text search template, which specifies the
functions that actually perform the work. Typically the dictionary provides some
options that control the detailed behavior of the template's functions.
If a schema name is given then the text search dictionary is created in the speci-
fied schema. Otherwise it is created in the current schema.
The user who defines a text search dictionary becomes its owner.
Refer to in the documentation for further information.
PARAMETERS
name The name of the text search dictionary to be created. The name can be
schema-qualified.
template
The name of the text search template that will define the basic behavior of
this dictionary.
option The name of a template-specific option to be set for this dictionary.
value The value to use for a template-specific option. If the value is not a sim-
ple identifier or number, it must be quoted (but you can always quote it, if
you wish).
The options can appear in any order.
EXAMPLES
The following example command creates a Snowball-based dictionary with a nonstan-
dard list of stop words.
CREATE TEXT SEARCH DICTIONARY my_russian (
template = snowball,
language = russian,
stopwords = myrussian
);
COMPATIBILITY
There is no CREATE TEXT SEARCH DICTIONARY statement in the SQL standard.
SEE ALSO
ALTER TEXT SEARCH DICTIONARY [alter_text_search_dictionary(7)], DROP TEXT SEARCH
DICTIONARY [drop_text_search_dictionary(l)]
SQL - Language Statements 2009-03-12 CREATE TEXT SEARCH DICTIONARY()
Generated by $Id: phpMan.php,v 4.54 2007/08/21 09:05:22 chedong Exp $ Author: Che Dong
On Apache/2.2.3 (Red Hat)
Under GNU General Public License
2009-12-24 04:34 @127.0.0.1 CrawledBy CCBot/1.0 (+http://www.commoncrawl.org/bot.html)