{"kind": "fts", "major": "18", "item": {"slug": "template-simple", "name": "simple", "name_zh": "", "category": "\u8bcd\u5178\u6a21\u677f", "summary": "simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd", "aliases": [], "content_hash": "35e51e73527c26974f523b78bf87760c622223de90c841e8cfe36e3e5f8a1ece", "versions": {"10": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "simple"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 10 English manual", "sha256": "3ebf526b3637016bf4e286a1d8e6b999f02824f9df4e53a9df9afdd0a06dc83d", "language": "en", "original_url": "/docs/10/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/10/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "simple dictionary: just lower case and check for stopword", "/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": "ca10da71b382604446e5d54991438da746f7b6e5daeb1a5cf9be4e82af3883dc"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "11": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "simple"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 11 English manual", "sha256": "64a862c0e84e4563364a0b25957c82ae3e7f368eb0631cb577a313b24dcf33c5", "language": "en", "original_url": "/docs/11/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/11/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "simple dictionary: just lower case and check for stopword", "/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": "b8e9c35d56d2f7288408a0efbb7d1df5e11093ef9dd9937138e47c19672a9ed9"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "12": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "simple"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 12 English manual", "sha256": "df18f72cb6bf91875eaeb91ff94177f66f55f2f38fa460f5ba915845d73222fa", "language": "en", "original_url": "/docs/12/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/12/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "simple dictionary: just lower case and check for stopword", "/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": "5242477b2a72afffae3ff97c88b77c591f2c6daab4fd0d8ed9372f1d6c5b3a1b"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "13": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "simple"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 13 English manual", "sha256": "617bc0fe217c1989535b72bb9d242cd58fa884b2dcad4c9c027392c653f94c04", "language": "en", "original_url": "/docs/13/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/13/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "simple dictionary: just lower case and check for stopword", "/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": "a1f73fb188f93997d7af9a57753eece8b1935af3184b28e31db3f07ae469ecd0"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "14": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "simple"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 14 English manual", "sha256": "09da9246ae189f5e996c5d28d3219abd42110b6cfb7f40dc6de950ebad61bb3b", "language": "en", "original_url": "/docs/14/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/14/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "simple dictionary: just lower case and check for stopword", "/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": "c1985d05a147d545d4e4a7684191a379fc0c0be74abcb601fa565cf3dd6e9f31"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "15": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "simple"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 15 English manual", "sha256": "2c07a3e6c2c585346fb28f44631ec3ddcd6a53d5c16c4bf7946ff8b51534929a", "language": "en", "original_url": "/docs/15/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/15/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "simple dictionary: just lower case and check for stopword", "/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": "ea93e3dec36eedba17414897bfee14516702b92742f6b8acc0025ea1c1ae4038"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "16": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "\u7b80\u5355"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 16 English manual", "sha256": "3a688880061676fa9389d35ac677baa2030b0a624a0c3a62c8d3f4cb2b9170d1", "language": "en", "original_url": "/docs/16/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/16/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}, {"url": "/docs/16/using-explain.html", "method": "same-major semantic node", "sha256": "a57dce89f2a7bb97c5428853ed29e289ea1527692d8e4b1aa331311048271790", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "simple dictionary: just lower case and check for stopword", "/versions/16/facts/0/label": "Tmplname", "/versions/16/facts/0/value": "simple", "/versions/16/facts/1/label": "Tmplinit", "/versions/16/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "9ca2404ebdcaf62fcc74f2137f4e4e7962f8707d2fe378221cb8b1a4c62c57e2"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "17": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "\u7b80\u5355"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 17 English manual", "sha256": "989f1a5af7ab9dfa2a07c1a2aefcdc2eddc889a3438d45eb94f1b2933b953fa6", "language": "en", "original_url": "/docs/17/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/17/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}, {"url": "/docs/17/using-explain.html", "method": "same-major semantic node", "sha256": "610ae355c419b53a5e213a8c8e2eacbf34e4fa0ac8f6d27365071bc6d3c90278", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "simple dictionary: just lower case and check for stopword", "/versions/17/facts/0/label": "Tmplname", "/versions/17/facts/0/value": "simple", "/versions/17/facts/1/label": "Tmplinit", "/versions/17/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "c101123c0055f7372796f1f4c9a195940aa585711492a33b3f728038b79657f4"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "18": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "\u7b80\u5355"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 18 English manual", "sha256": "736b212545d12542777fa6d106bbf5b159fe5617123a208d36a8a572130c3fa6", "language": "en", "original_url": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}, {"url": "/docs/18/using-explain.html", "method": "same-major semantic node", "sha256": "b8835ec9adbc70ec150667a6b5443f8d298222dc0cc8c2bd1abb1c1d64895904", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "simple dictionary: just lower case and check for stopword", "/versions/18/facts/0/label": "Tmplname", "/versions/18/facts/0/value": "simple", "/versions/18/facts/1/label": "Tmplinit", "/versions/18/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ec0ca601756f329ef77dcc65217b48295760dec79ea9981aa8a750b7ccc59f6f"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "19": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "\u7b80\u5355"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 19 English manual", "sha256": "cf8d1204d2952cb7b89b234f1c4f2c9c19cfa5c5a81108be7108815002f2c593", "language": "en", "original_url": "/docs/19/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/19/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}, {"url": "/docs/19/using-explain.html", "method": "same-major semantic node", "sha256": "7cc78f59bf29afb1811ece53e9d5c572a3f634d66d7422fb8761f19bc6811492", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "simple dictionary: just lower case and check for stopword", "/versions/19/facts/0/label": "Tmplname", "/versions/19/facts/0/value": "simple", "/versions/19/facts/1/label": "Tmplinit", "/versions/19/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "1bbf16c582edfb4af10b86b4f51a34fec631a0eb6af672a86647a45d1ba92ade"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "20": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "\u7b80\u5355"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 20 English manual", "sha256": "38c6f6073ed98b8e321cad040c89265f00a6fe755aa68f0f1a28a1ad1457c9c0", "language": "en", "original_url": "/docs/devel/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/devel/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}, {"url": "/docs/devel/using-explain.html", "method": "same-major semantic node", "sha256": "2744ee0e88d132c504bf5e102765edaabd393eb12c59294093db6d90b26dd65c", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/summary": "simple dictionary: just lower case and check for stopword", "/category": "Dictionary templates", "/versions/20/description/0": "simple dictionary: just lower case and check for stopword", "/versions/20/facts/0/label": "Tmplname", "/versions/20/facts/0/value": "simple", "/versions/20/facts/1/label": "Tmplinit", "/versions/20/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "0d20a1005a1f1e85884fd76f38610fd9fe7cd0776072fccb83f143743a6973d3"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u6a21\u677f\u540d\u79f0\uff08tmplname\uff09", "value": "\u7b80\u5355"}, {"label": "\u521d\u59cb\u5316\u51fd\u6570\uff08tmplinit\uff09", "value": "dsimple_init"}, {"label": "\u8bcd\u6cd5\u5316\u51fd\u6570\uff08tmpllexize\uff09", "value": "dsimple_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-SIMPLE-DICTIONARY", "path": "textsearch-dictionaries.html", "label": "PostgreSQL 18 English manual", "sha256": "736b212545d12542777fa6d106bbf5b159fe5617123a208d36a8a572130c3fa6", "language": "en", "original_url": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY"}], "sections": [], "signature": "", "attributes": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "description": ["simple \u8bcd\u5178\uff1a\u4ec5\u8f6c\u6362\u4e3a\u5c0f\u5199\u5e76\u68c0\u67e5\u505c\u7528\u8bcd"], "manual_html": "<div class=\"sect2\" id=\"TEXTSEARCH-SIMPLE-DICTIONARY\">\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-SIMPLE-DICTIONARY\">12.6.2. \u7b80\u5355\u8bcd\u5178</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\"><code class=\"literal\">simple</code> \u8bcd\u5178\u6a21\u677f\u7684\u5de5\u4f5c\u65b9\u5f0f\u662f\u5148\u628a\u8f93\u5165\u8bcd\u5143\u8f6c\u6362\u4e3a\u5c0f\u5199\uff0c\u518d\u6839\u636e\u505c\u7528\u8bcd\u6587\u4ef6\u68c0\u67e5\u5b83\u3002\u5982\u679c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u8be5\u8bcd\u5143\uff0c\u5c31\u8fd4\u56de\u4e00\u4e2a\u7a7a\u6570\u7ec4\uff0c\u4ece\u800c\u4e22\u5f03\u8be5\u8bcd\u5143\uff1b\u5426\u5219\uff0c\u8fd4\u56de\u5176\u5c0f\u5199\u5f62\u5f0f\u4f5c\u4e3a\u6b63\u89c4\u5316\u540e\u7684\u8bcd\u4f4d\u3002\u6216\u8005\uff0c\u4e5f\u53ef\u4ee5\u628a\u8be5\u8bcd\u5178\u914d\u7f6e\u4e3a\u628a\u975e\u505c\u7528\u8bcd\u62a5\u544a\u4e3a\u672a\u8bc6\u522b\uff0c\u4ece\u800c\u5141\u8bb8\u5b83\u4eec\u4f20\u9012\u7ed9\u5217\u8868\u4e2d\u7684\u4e0b\u4e00\u4e2a\u8bcd\u5178\u3002</p>\n<p lang=\"zh\">\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528 <code class=\"literal\">simple</code> \u6a21\u677f\u7684\u8bcd\u5178\u5b9a\u4e49\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY public.simple_dict (\n    TEMPLATE = pg_catalog.simple,\n    STOPWORDS = english\n);\n</pre>\n<p lang=\"zh\">\u5176\u4e2d\uff0c<code class=\"literal\">english</code> \u662f\u505c\u7528\u8bcd\u6587\u4ef6\u7684\u57fa\u540d\u3002\u6587\u4ef6\u5b8c\u6574\u540d\u79f0\u5c06\u662f <code class=\"filename\">$SHAREDIR/tsearch_data/english.stop</code>\uff0c\u5176\u4e2d <code class=\"literal\">$SHAREDIR</code> \u8868\u793a <span class=\"productname\">PostgreSQL</span> \u5b89\u88c5\u7684\u5171\u4eab\u6570\u636e\u76ee\u5f55\uff0c\u901a\u5e38\u662f <code class=\"filename\">/usr/local/share/postgresql</code>\uff08\u5982\u679c\u4e0d\u786e\u5b9a\uff0c\u53ef\u7528 <code class=\"command\">pg_config --sharedir</code> \u6765\u786e\u5b9a\uff09\u3002\u6587\u4ef6\u683c\u5f0f\u53ea\u662f\u4e00\u4e2a\u5355\u8bcd\u5217\u8868\uff0c\u6bcf\u884c\u4e00\u4e2a\u5355\u8bcd\u3002\u7a7a\u884c\u548c\u884c\u5c3e\u7a7a\u683c\u4f1a\u88ab\u5ffd\u7565\uff0c\u5927\u5199\u4f1a\u6298\u53e0\u4e3a\u5c0f\u5199\uff0c\u4f46\u4e0d\u4f1a\u5bf9\u6587\u4ef6\u5185\u5bb9\u505a\u5176\u4ed6\u5904\u7406\u3002</p>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u8fd9\u4e2a\u8bcd\u5178\uff1a</p>\n<pre class=\"screen\">SELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n {yes}\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5982\u679c\u5728\u505c\u7528\u8bcd\u6587\u4ef6\u4e2d\u627e\u4e0d\u5230\u8be5\u8bcd\uff0c\u6211\u4eec\u4e5f\u53ef\u4ee5\u9009\u62e9\u8fd4\u56de <code class=\"literal\">NULL</code>\uff0c\u800c\u4e0d\u662f\u8fd4\u56de\u5b83\u7684\u5c0f\u5199\u5f62\u5f0f\u3002\u8fd9\u79cd\u884c\u4e3a\u53ef\u4ee5\u901a\u8fc7\u628a\u8bcd\u5178\u7684 <code class=\"literal\">Accept</code> \u53c2\u6570\u8bbe\u7f6e\u4e3a <code class=\"literal\">false</code> \u6765\u542f\u7528\u3002\u7ee7\u7eed\u4e0a\u9762\u7684\u4f8b\u5b50\uff1a</p>\n<pre class=\"screen\">ALTER TEXT SEARCH DICTIONARY public.simple_dict ( Accept = false );\n\nSELECT ts_lexize('public.simple_dict', 'YeS');\n ts_lexize\n-----------\n\n\nSELECT ts_lexize('public.simple_dict', 'The');\n ts_lexize\n-----------\n {}\n</pre>\n<p lang=\"zh\">\u5728\u9ed8\u8ba4\u8bbe\u7f6e <code class=\"literal\">Accept</code> = <code class=\"literal\">true</code> \u4e0b\uff0c\u53ea\u6709\u628a <code class=\"literal\">simple</code> \u8bcd\u5178\u653e\u5728\u8bcd\u5178\u5217\u8868\u672b\u5c3e\u624d\u6709\u610f\u4e49\uff0c\u56e0\u4e3a\u5b83\u4e0d\u4f1a\u628a\u4efb\u4f55\u8bcd\u5143\u4f20\u9012\u7ed9\u540e\u7eed\u8bcd\u5178\u3002\u76f8\u53cd\uff0c<code class=\"literal\">Accept</code> = <code class=\"literal\">false</code> \u53ea\u6709\u5728\u540e\u9762\u81f3\u5c11\u8fd8\u6709\u4e00\u4e2a\u8bcd\u5178\u65f6\u624d\u6709\u7528\u3002</p>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u5927\u591a\u6570\u8bcd\u5178\u7c7b\u578b\u90fd\u4f9d\u8d56\u914d\u7f6e\u6587\u4ef6\uff0c\u4f8b\u5982\u505c\u7528\u8bcd\u6587\u4ef6\u3002\u8fd9\u4e9b\u6587\u4ef6<span class=\"emphasis\"><em>\u5fc5\u987b</em></span>\u91c7\u7528 UTF-8 \u7f16\u7801\u4fdd\u5b58\u3002\u5f53\u5b83\u4eec\u88ab\u8bfb\u5165\u670d\u52a1\u5668\u65f6\uff0c\u5982\u679c\u6570\u636e\u5e93\u7f16\u7801\u4e0d\u540c\uff0c\u5c31\u4f1a\u88ab\u8f6c\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u7f16\u7801\u3002</p>\n</div>\n<div class=\"caution\">\n<h3 class=\"title\" lang=\"zh\">\u5c0f\u5fc3</h3>\n<p lang=\"zh\">\u901a\u5e38\uff0c\u8bcd\u5178\u914d\u7f6e\u6587\u4ef6\u5728\u67d0\u4e2a\u6570\u636e\u5e93\u4f1a\u8bdd\u4e2d\u7b2c\u4e00\u6b21\u88ab\u4f7f\u7528\u65f6\uff0c\u53ea\u4f1a\u88ab\u8bfb\u53d6\u4e00\u6b21\u3002\u5982\u679c\u4f60\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\uff0c\u5e76\u5e0c\u671b\u5f3a\u5236\u73b0\u6709\u4f1a\u8bdd\u52a0\u8f7d\u65b0\u5185\u5bb9\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8bcd\u5178\u6267\u884c\u4e00\u6761 <code class=\"command\">ALTER TEXT SEARCH DICTIONARY</code> \u547d\u4ee4\u3002\u8fd9\u53ef\u4ee5\u662f\u4e00\u6761<span class=\"quote\">\u201c<span class=\"quote\">\u5047</span>\u201d</span>\u66f4\u65b0\uff0c\u4e5f\u5c31\u662f\u5e76\u4e0d\u5b9e\u9645\u4fee\u6539\u4efb\u4f55\u53c2\u6570\u503c\u7684\u66f4\u65b0\u3002</p>\n</div>\n</div>", "manual_path": "/docs/18/textsearch-dictionaries.html#TEXTSEARCH-SIMPLE-DICTIONARY", "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[13]/div[10]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/div[11]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[1]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[2]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[4]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[5]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[7]", "#TEXTSEARCH-DICTIONARIES/div[13]/p[9]", "#TEXTSEARCH-DICTIONARIES/div[1]/dl[0]/dt[1]"]}, {"url": "/docs/18/using-explain.html", "method": "same-major semantic node", "sha256": "b8835ec9adbc70ec150667a6b5443f8d298222dc0cc8c2bd1abb1c1d64895904", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "simple dictionary: just lower case and check for stopword", "/versions/18/facts/0/label": "Tmplname", "/versions/18/facts/0/value": "simple", "/versions/18/facts/1/label": "Tmplinit", "/versions/18/facts/2/label": "Tmpllexize"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ec0ca601756f329ef77dcc65217b48295760dec79ea9981aa8a750b7ccc59f6f"}, "comparison_data": {"tmplinit": "dsimple_init", "tmplname": "simple", "tmpllexize": "dsimple_lexize"}, "comparison_hash": "8cbf3dd48f5ea9953df2c98b030f06e99c60e74931ff399b86859431c90ab9a7", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}