{"kind": "fts", "major": "18", "item": {"slug": "template-thesaurus", "name": "thesaurus", "name_zh": "", "category": "\u8bcd\u5178\u6a21\u677f", "summary": "thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362", "aliases": [], "content_hash": "963857db512bafb90d6cf246a2018842326c48d73f8b42d3a2b114c028d8dfdd", "versions": {"10": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "historical", "revision": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9", "catalog_fingerprint": "691be281b476dde4374d7f805b2bacc2e75bdef40f1e9d3d42e91f97fe95cfd0"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, {"url": "https://pg.center/docs/10/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 10 English manual", "sha256": "3ebf526b3637016bf4e286a1d8e6b999f02824f9df4e53a9df9afdd0a06dc83d", "language": "en", "original_url": "/docs/10/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/10/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre></div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre></div>\n</div>", "manual_path": "/docs/10/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/10/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "c0157f280c8667dde264cddda98e48a2fcb0694fe7a009e90c7c844e3e0c057c", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/10/facts/0/label": "Tmplname", "/versions/10/facts/1/label": "Tmplinit", "/versions/10/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f83c9bbe67ee84070eaf7c0ce1ebf317cefdcc2bf66d6d9bc29a4388ad5f8579"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "11": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "historical", "revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0", "catalog_fingerprint": "8f21f4444b7f68923f4762af0eb7937fa2907026e91249483e79050de012c901"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, {"url": "https://pg.center/docs/11/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 11 English manual", "sha256": "64a862c0e84e4563364a0b25957c82ae3e7f368eb0631cb577a313b24dcf33c5", "language": "en", "original_url": "/docs/11/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/11/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/11/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/11/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "d52d2e8077f1105a699bb46869e8b6a646c56eb3206e5486b6b8cf3a571ece59", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/11/facts/0/label": "Tmplname", "/versions/11/facts/1/label": "Tmplinit", "/versions/11/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "47d2d26b59e021853dc7c924a538f4b5c86f3fceb309ce1036e4b9d49e9f3112"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "12": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "historical", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b", "catalog_fingerprint": "9f857f4ee4875f9c7de6bfc9df4b757dec8b3a0bb88eadb519c7bd267bd56149"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, {"url": "https://pg.center/docs/12/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 12 English manual", "sha256": "df18f72cb6bf91875eaeb91ff94177f66f55f2f38fa460f5ba915845d73222fa", "language": "en", "original_url": "/docs/12/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/12/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/12/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/12/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "eb039d3d941f91d46f2fbcbf543928e06f02b7a99611256dd78f53ef2b9c616f", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/12/facts/0/label": "Tmplname", "/versions/12/facts/1/label": "Tmplinit", "/versions/12/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "0901c626131f0c1db3e6c675f599cc8c78d29b98f0126078f25e3073ad18cd56"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "13": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "historical", "revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6", "catalog_fingerprint": "c7015c845255c9d721c547c8ab9ef37825d332588c9691d982e6906b7d571002"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, {"url": "https://pg.center/docs/13/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 13 English manual", "sha256": "617bc0fe217c1989535b72bb9d242cd58fa884b2dcad4c9c027392c653f94c04", "language": "en", "original_url": "/docs/13/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/13/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/13/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/13/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "c7e699ef8c49c765eb3e1103893bd4f0d22be3cad4ebeecdb7963d868dab3d5c", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/13/facts/0/label": "Tmplname", "/versions/13/facts/1/label": "Tmplinit", "/versions/13/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "9efa2534f0cc87337e8704599a160e07fdeaa0d795426ef9d1eac88ee4868d06"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "14": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "catalog_fingerprint": "b272e6a82e4c46efda81c3a6a4cdf7de6a83dfff7f02f226a392fbe9acdd3adb"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, {"url": "https://pg.center/docs/14/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 14 English manual", "sha256": "09da9246ae189f5e996c5d28d3219abd42110b6cfb7f40dc6de950ebad61bb3b", "language": "en", "original_url": "/docs/14/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/14/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/14/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/14/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "c84d880a14dfc2f06213b03bb92f6231a135dda3dbb8ff8293fe8ec73b884851", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/14/facts/0/label": "Tmplname", "/versions/14/facts/1/label": "Tmplinit", "/versions/14/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "23e9a7a6510d077a89831662f95b7a47ff0fb49846f9cb55b9a790979d879cd7"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "15": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "catalog_fingerprint": "fefe3c425147a86defada190c9b0663cfe02caa1724f5dede93e46457572252d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, {"url": "https://pg.center/docs/15/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 15 English manual", "sha256": "2c07a3e6c2c585346fb28f44631ec3ddcd6a53d5c16c4bf7946ff8b51534929a", "language": "en", "original_url": "/docs/15/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/15/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/15/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/15/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "8ea2b1afa7f5da82bd0045f7479243d49615c62e9fa9b70f6068353416581409", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/15/facts/0/label": "Tmplname", "/versions/15/facts/1/label": "Tmplinit", "/versions/15/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "8f72132554f20b43ab30e44de9574e72bcd0456e39c21c973b10d823c2acd720"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "16": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "catalog_fingerprint": "fa133458dc8f52e15083b4f59b7a582e2e378b608d3ac5c53054df458a374e23"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, {"url": "https://pg.center/docs/16/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 16 English manual", "sha256": "3a688880061676fa9389d35ac677baa2030b0a624a0c3a62c8d3f4cb2b9170d1", "language": "en", "original_url": "/docs/16/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/16/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/16/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/16/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "430a0ff98acc6b0bec92c2b77ff50493ea5328b5eccce1bc0f4991a53ac16ddf", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/16/facts/0/label": "Tmplname", "/versions/16/facts/1/label": "Tmplinit", "/versions/16/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "2e6548996163519de0c7b2d868f76327d4cef7eab96c32bf547c5cf0070f7b2d"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "17": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "catalog_fingerprint": "4bbe3ac77becd618478f66aec420a533e9017be356c5c1d51a4b17f0fd497c07"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, {"url": "https://pg.center/docs/17/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 17 English manual", "sha256": "989f1a5af7ab9dfa2a07c1a2aefcdc2eddc889a3438d45eb94f1b2933b953fa6", "language": "en", "original_url": "/docs/17/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/17/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/17/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/17/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "9ae724601e3e21dc17e22f93fdf7cb7ec6676cf9c7146d94abffd816534cd171", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/17/facts/0/label": "Tmplname", "/versions/17/facts/1/label": "Tmplinit", "/versions/17/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "43732ab5c802ded659ba2588279676223f4729482470d6a62e0c5113083aa5c0"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "18": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "catalog_fingerprint": "65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 18 English manual", "sha256": "736b212545d12542777fa6d106bbf5b159fe5617123a208d36a8a572130c3fa6", "language": "en", "original_url": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/18/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "afe47fea3be000f5266417ceecb464ae02e5dc05e02d8d38976bd9fcf2d84563", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/18/facts/0/label": "Tmplname", "/versions/18/facts/1/label": "Tmplinit", "/versions/18/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "b1edb5aa2a69500843c5a926b7a4018517e58d9a73d4f6456f433b015540eb59"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "19": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "catalog_fingerprint": "62fbf1a3689dbe8bf7e6b3372cfe6fbf867581427b3858a94c8419b77a4d2d1d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "https://pg.center/docs/19/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 19 English manual", "sha256": "cf8d1204d2952cb7b89b234f1c4f2c9c19cfa5c5a81108be7108815002f2c593", "language": "en", "original_url": "/docs/19/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/19/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/19/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/19/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "c867ceccebd59d165b0d78a4b0c0307529ac3bc90c9183020b322507ce0e1870", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/19/facts/0/label": "Tmplname", "/versions/19/facts/1/label": "Tmplinit", "/versions/19/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "86141ed61908e6dd218d6a6d1be9662a3623431a1383b2ca002dc4175c1d30b2"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "20": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "catalog_fingerprint": "398fbb9f262264053c02fbf79f88be0a6770c1473faa6ecd5931d6ec41b8258b", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "https://pg.center/docs/devel/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 20 English manual", "sha256": "38c6f6073ed98b8e321cad040c89265f00a6fe755aa68f0f1a28a1ad1457c9c0", "language": "en", "original_url": "/docs/devel/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/devel/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/devel/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "682603a92eb3390ca6eef864d76a77272216806e918815781321c56df0c777a3", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/summary": "thesaurus dictionary: phrase by phrase substitution", "/category": "Dictionary templates", "/versions/20/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/20/facts/0/label": "Tmplname", "/versions/20/facts/1/label": "Tmplinit", "/versions/20/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "4aebe7b2434e01e71f461e0fc5f50154022ab1e70066ba0f664dcea3891579e0"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "thesaurus"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "thesaurus_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "thesaurus_lexize"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "catalog_fingerprint": "65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 18 English manual", "sha256": "736b212545d12542777fa6d106bbf5b159fe5617123a208d36a8a572130c3fa6", "language": "en", "original_url": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS"}], "sections": [], "signature": "", "attributes": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "description": ["thesaurus \u8bcd\u5178\uff1a\u9010\u77ed\u8bed\u66ff\u6362"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-THESAURUS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS\">12.6.4. \u5206\u7c7b\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8bcd\u7ec4\u8bcd\u5178\uff08\u6709\u65f6\u7f29\u5199\u4e3a TZ\uff09\u662f\u4e00\u7ec4\u5305\u542b\u8bcd\u8bed\u53ca\u77ed\u8bed\u4e4b\u95f4\u5173\u7cfb\u4fe1\u606f\u7684\u8bcd\u6c47\u96c6\u5408\uff0c\u4f8b\u5982\u4e0a\u4f4d\u8bcd\uff08BT\uff09\u3001\u4e0b\u4f4d\u8bcd\uff08NT\uff09\u3001\u9996\u9009\u8bcd\u3001\u975e\u9996\u9009\u8bcd\u3001\u76f8\u5173\u8bcd\u7b49\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u57fa\u672c\u4e0a\u4f1a\u7528\u4e00\u4e2a\u9996\u9009\u8bcd\u66ff\u6362\u6240\u6709\u975e\u9996\u9009\u8bcd\uff0c\u5e76\u4e14\u4e5f\u53ef\u4ee5\u9009\u62e9\u4fdd\u7559\u539f\u59cb\u8bcd\u7528\u4e8e\u7d22\u5f15\u3002<span class=\"productname\">PostgreSQL</span>\u7684\u5206\u7c7b\u8bcd\u5178\u7684\u5f53\u524d\u5b9e\u73b0\u662f\u540c\u4e49\u8bcd\u8bcd\u5178\u7684\u4e00\u4e2a\u6269\u5c55\uff0c\u5e76\u589e\u52a0\u4e86<em class=\"firstterm\">\u77ed\u8bed</em>\u652f\u6301\u3002\u4e00\u4e2a\u5206\u7c7b\u8bcd\u5178\u9700\u8981\u4e00\u4e2a\u91c7\u7528\u4ee5\u4e0b\u683c\u5f0f\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\"># this is a comment\nsample word(s) : indexed word(s)\nmore sample word(s) : more indexed word(s)\n...\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\u5192\u53f7\uff08<code class=\"symbol\">:</code>\uff09\u7b26\u53f7\u7528\u4f5c\u77ed\u8bed\u53ca\u5176\u66ff\u6362\u8bcd\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002</p>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u4f7f\u7528\u4e00\u4e2a<em class=\"firstterm\">\u5b50\u8bcd\u5178</em>\uff08\u5728\u8bcd\u5178\u914d\u7f6e\u4e2d\u6307\u5b9a\uff09\u5728\u68c0\u67e5\u77ed\u8bed\u5339\u914d\u4e4b\u524d\u6b63\u89c4\u5316\u8f93\u5165\u6587\u672c\u3002\u53ea\u80fd\u9009\u62e9\u4e00\u4e2a\u5b50\u8bcd\u5178\u3002\u5982\u679c\u5b50\u8bcd\u5178\u65e0\u6cd5\u8bc6\u522b\u67d0\u4e2a\u8bcd\uff0c\u5c31\u4f1a\u62a5\u9519\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u5e94\u5f53\u907f\u514d\u4f7f\u7528\u8be5\u8bcd\uff0c\u6216\u8005\u8ba9\u5b50\u8bcd\u5178\u5b66\u4f1a\u5b83\u3002\u4f60\u53ef\u4ee5\u5728\u67d0\u4e2a\u88ab\u7d22\u5f15\u8bcd\u7684\u5f00\u5934\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08<code class=\"symbol\">*</code>\uff09\uff0c\u4ee5\u8df3\u8fc7\u5c06\u5b50\u8bcd\u5178\u5e94\u7528\u4e8e\u8be5\u8bcd\uff0c\u4f46\u6240\u6709\u6837\u4f8b\u8bcd\u90fd<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u80fd\u88ab\u5b50\u8bcd\u5178\u8bc6\u522b\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u6709\u591a\u4e2a\u77ed\u8bed\u5339\u914d\u8f93\u5165\uff0c\u5206\u7c7b\u8bcd\u5178\u4f1a\u9009\u62e9\u6700\u957f\u7684\u5339\u914d\uff1b\u957f\u5ea6\u76f8\u540c\u65f6\u4f7f\u7528\u6700\u540e\u7684\u5b9a\u4e49\u3002</p>\n<p lang=\"zh\">\u7531\u5b50\u8bcd\u5178\u8bc6\u522b\u7684\u7279\u5b9a\u505c\u7528\u8bcd\u4e0d\u80fd\u591f\u88ab\u6307\u5b9a\uff1b\u6539\u7528<code class=\"literal\">?</code>\u6807\u8bb0\u53ef\u51fa\u73b0\u4efb\u610f\u505c\u7528\u8bcd\u7684\u4f4d\u7f6e\u3002\u4f8b\u5982\uff0c\u5047\u5b9a\u6839\u636e\u5b50\u8bcd\u5178<code class=\"literal\">a</code>\u548c<code class=\"literal\">the</code>\u662f\u505c\u7528\u8bcd\uff1a</p>\n<pre class=\"programlisting\">? one ? two : swsw\n</pre>\n<p lang=\"zh\">\u5339\u914d<code class=\"literal\">a one the two</code>\u548c<code class=\"literal\">the one a two</code>\uff1b\u4e24\u8005\u90fd\u5c06\u88ab<code class=\"literal\">swsw</code>\u66ff\u6362\u3002</p>\n<p lang=\"zh\">\u7531\u4e8e\u5206\u7c7b\u8bcd\u5178\u5177\u5907\u8bc6\u522b\u77ed\u8bed\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u5b83\u5fc5\u987b\u8bb0\u4f4f\u81ea\u8eab\u72b6\u6001\u5e76\u4e0e\u89e3\u6790\u5668\u4ea4\u4e92\u3002\u5206\u7c7b\u8bcd\u5178\u4f1a\u5229\u7528\u8fd9\u4e9b\u6620\u5c04\u5173\u7cfb\u6765\u5224\u65ad\u81ea\u5df1\u662f\u5e94\u5f53\u5904\u7406\u4e0b\u4e00\u4e2a\u8bcd\uff0c\u8fd8\u662f\u505c\u6b62\u7d2f\u79ef\u3002\u5206\u7c7b\u8bcd\u5178\u5fc5\u987b\u7ecf\u8fc7\u4ed4\u7ec6\u914d\u7f6e\u3002\u4f8b\u5982\uff0c\u5982\u679c\u5206\u7c7b\u8bcd\u5178\u53ea\u88ab\u6620\u5c04\u5230 <code class=\"literal\">asciiword</code> \u8bcd\u5143\uff0c\u90a3\u4e48\u50cf <code class=\"literal\">one 7</code> \u8fd9\u6837\u7684\u5206\u7c7b\u8bcd\u5178\u5b9a\u4e49\u5c31\u65e0\u6cd5\u5de5\u4f5c\uff0c\u56e0\u4e3a\u8bcd\u5143\u7c7b\u578b <code class=\"literal\">uint</code> \u5e76\u6ca1\u6709\u6620\u5c04\u7ed9\u8be5\u5206\u7c7b\u8bcd\u5178\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5206\u7c7b\u8bcd\u5178\u4f1a\u5728\u5efa\u7acb\u7d22\u5f15\u65f6\u4f7f\u7528\uff0c\u56e0\u6b64\u5176\u53c2\u6570\u53d1\u751f\u4efb\u4f55\u53d8\u5316\u90fd<span class=\"emphasis\"><em>\u8981\u6c42</em></span>\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002\u5bf9\u4e8e\u5927\u591a\u6570\u5176\u4ed6\u8bcd\u5178\u7c7b\u578b\uff0c\u50cf\u589e\u52a0\u6216\u79fb\u9664\u505c\u7528\u8bcd\u8fd9\u6837\u7684\u7ec6\u5c0f\u6539\u52a8\u5219\u4e0d\u4f1a\u5f3a\u5236\u91cd\u65b0\u5efa\u7acb\u7d22\u5f15\u3002</p>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-CONFIG\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.1.\u00a0\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8981\u5b9a\u4e49\u4e00\u4e2a\u65b0\u7684\u5206\u7c7b\u8bcd\u5178\uff0c\u53ef\u4f7f\u7528<code class=\"literal\">thesaurus</code>\u6a21\u677f\u3002\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_simple (\n    TEMPLATE = thesaurus,\n    DictFile = mythesaurus,\n    Dictionary = pg_catalog.english_stem\n);\n</pre>\n<p lang=\"zh\">\u8fd9\u91cc\uff1a</p>\n<div class=\"itemizedlist\">\n<ul class=\"itemizedlist compact\">\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">thesaurus_simple</code>\u662f\u65b0\u8bcd\u5178\u7684\u540d\u79f0</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">mythesaurus</code>\u662f\u5206\u7c7b\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u7684\u57fa\u540d\uff08\u5b83\u7684\u5168\u540d\u5c06\u662f<code class=\"filename\">$SHAREDIR/tsearch_data/mythesaurus.ths</code>\uff0c\u5176\u4e2d<code class=\"literal\">$SHAREDIR</code>\u8868\u793a\u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff09\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p><code class=\"literal\">pg_catalog.english_stem</code>\u662f\u8981\u7528\u4e8e\u5206\u7c7b\u8bcd\u5178\u6b63\u89c4\u5316\u7684\u5b50\u8bcd\u5178\uff08\u8fd9\u91cc\u662f\u4e00\u4e2a Snowball \u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\uff09\u3002\u6ce8\u610f\u5b50\u8bcd\u5178\u5c06\u62e5\u6709\u5b83\u81ea\u5df1\u7684\u914d\u7f6e\uff08\u4f8b\u5982\u505c\u7528\u8bcd\uff09\uff0c\u4f46\u8fd9\u91cc\u6ca1\u6709\u5c55\u793a\u3002</p>\n</li>\n</ul>\n</div>\n<p lang=\"zh\">\u73b0\u5728\u53ef\u4ee5\u5728\u914d\u7f6e\u4e2d\u628a\u5206\u7c7b\u8bcd\u5178<code class=\"literal\">thesaurus_simple</code>\u7ed1\u5b9a\u5230\u60f3\u8981\u7684\u8bcd\u5143\u7c7b\u578b\u4e0a\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_simple;\n</pre>\n</div>\n<div class=\"sect3\" id=\"TEXTSEARCH-THESAURUS-EXAMPLES\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">12.6.4.2.\u00a0\u5206\u7c7b\u8bcd\u5178\u793a\u4f8b </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u8003\u8651\u4e00\u4e2a\u7b80\u5355\u7684\u5929\u6587\u5206\u7c7b\u8bcd\u5178 <code class=\"literal\">thesaurus_astro</code>\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e9b\u5929\u6587\u5355\u8bcd\u7ec4\u5408\uff1a</p>\n<pre class=\"programlisting\">supernovae stars : sn\ncrab nebulae : crab\n</pre>\n<p lang=\"zh\">\u4e0b\u9762\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u8bcd\u5178\uff0c\u5e76\u628a\u4e00\u4e9b\u8bcd\u5143\u7c7b\u578b\u7ed1\u5b9a\u5230\u5929\u6587\u5206\u7c7b\u8bcd\u5178\u548c\u82f1\u8bed\u8bcd\u5e72\u5206\u6790\u5668\u4e0a\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY thesaurus_astro (\n    TEMPLATE = thesaurus,\n    DictFile = thesaurus_astro,\n    Dictionary = english_stem\n);\n\nALTER TEXT SEARCH CONFIGURATION russian\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart\n    WITH thesaurus_astro, english_stem;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u770b\u770b\u5b83\u662f\u5982\u4f55\u5de5\u4f5c\u7684\u3002<code class=\"function\">ts_lexize</code> \u5bf9\u6d4b\u8bd5\u5206\u7c7b\u8bcd\u5178\u5e76\u4e0d\u5341\u5206\u6709\u7528\uff0c\u56e0\u4e3a\u5b83\u628a\u8f93\u5165\u5f53\u4f5c\u4e00\u4e2a\u5355\u72ec\u7684\u8bcd\u5143\u3002\u76f8\u53cd\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">plainto_tsquery</code> \u548c <code class=\"function\">to_tsvector</code>\uff0c\u5b83\u4eec\u4f1a\u628a\u8f93\u5165\u5b57\u7b26\u4e32\u62c6\u5206\u6210\u591a\u4e2a\u8bcd\u5143\uff1a</p>\n<pre class=\"screen\">SELECT plainto_tsquery('supernova star');\n plainto_tsquery\n-----------------\n 'sn'\n\nSELECT to_tsvector('supernova star');\n to_tsvector\n-------------\n 'sn':1\n</pre>\n<p lang=\"zh\">\u539f\u5219\u4e0a\uff0c\u5982\u679c\u628a\u53c2\u6570\u7528\u5f15\u53f7\u62ec\u8d77\u6765\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528 <code class=\"function\">to_tsquery</code>\uff1a</p>\n<pre class=\"screen\">SELECT to_tsquery('''supernova star''');\n to_tsquery\n------------\n 'sn'\n</pre>\n<p lang=\"zh\">\u5728 thesaurus_astro \u4e2d\uff0csupernova star \u80fd\u5339\u914d supernovae stars\uff0c\u56e0\u4e3a\u8bcd\u7ec4\u8bcd\u5178\u5b9a\u4e49\u4e2d\u6307\u5b9a\u4e86 english_stem \u8bcd\u5e72\u63d0\u53d6\u5668\uff1b\u5b83\u53bb\u6389\u4e86 e \u548c s\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u65e2\u8981\u4e3a\u66ff\u6362\u8bcd\u5efa\u7acb\u7d22\u5f15\uff0c\u4e5f\u8981\u4e3a\u539f\u59cb\u77ed\u8bed\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u628a\u539f\u59cb\u77ed\u8bed\u4e5f\u5199\u5230\u5b9a\u4e49\u53f3\u4fa7\u5373\u53ef\uff1a</p>\n<pre class=\"screen\">supernovae stars : sn supernovae stars\n\nSELECT plainto_tsquery('supernova star');\n       plainto_tsquery\n-----------------------------\n 'sn' &amp; 'supernova' &amp; 'star'\n</pre>\n</div>\n</div>", "manual_path": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS", "localization": {"status": "complete", "sources": [{"url": "/docs/18/textsearch-dictionaries.html", "method": "same-major semantic node", "sha256": "afe47fea3be000f5266417ceecb464ae02e5dc05e02d8d38976bd9fcf2d84563", "language": "zh", "matched_nodes": ["#TEXTSEARCH-DICTIONARIES/div[13]/div[10]/h3[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/div[4]/ul[0]/li[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[12]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/div[0]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[3]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[10]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[6]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[15]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[3]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "thesaurus dictionary: phrase by phrase substitution", "/versions/18/facts/0/label": "Tmplname", "/versions/18/facts/1/label": "Tmplinit", "/versions/18/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "b1edb5aa2a69500843c5a926b7a4018517e58d9a73d4f6456f433b015540eb59"}, "comparison_data": {"tmplinit": "thesaurus_init", "tmplname": "thesaurus", "tmpllexize": "thesaurus_lexize"}, "comparison_hash": "11904170699577864c7847708e60c97541f07dd8c8de3aae160655079b9bb0d9", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}