{"Entry":{"collection":"func","key":"pg-index-has-property","name":"pg_index_has_property","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.6"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"14"},{"descriptions_changed":true,"doc_overhaul":false,"from":"14","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"15"},{"descriptions_changed":true,"doc_overhaul":false,"from":"15","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"16"},{"descriptions_changed":true,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"17"},{"descriptions_changed":true,"doc_overhaul":false,"from":"17","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"18"},{"descriptions_changed":true,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"19"}],"content_hash":"046bc935f66afe04412cafb2daf93f5552ff0cee6253f9406bad7578b1bb5dde","derived_content_hash":"d99cb3fe9bcaff1ea6b439b311db3ff99848054aa04a85e54c0842cbef0fc866","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:d06f09c88dab821aafb94bdaccfb0f3f301a68c1cb43f2f6a0bf7cda49907b43","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.6","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.248682+08:00","last_version":"20","name":"pg_index_has_property","name_key":"pg_index_has_property","position":28082,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"756612c2109bb52db38cb914d509bfac031419246a05844d048678ad39f00dc0","repair":"wiki-repair-20261023"},"signature":"pg_index_has_property ( index regclass, property text ) → boolean","signature_count":1,"slug":"pg-index-has-property","source_rev":"wiki-repair-20261023:d06f09c88dab821aafb94bdaccfb0f3f301a68c1cb43f2f6a0bf7cda49907b43","summary":"Tests whether an index has the named property.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-index-has-property","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-index-has-property","SourceRevision":"wiki-repair-20261023:d06f09c88dab821aafb94bdaccfb0f3f301a68c1cb43f2f6a0bf7cda49907b43","Facts":{"description":"Tests whether an index has the named property. Common index properties are listed in Table 9.78. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_html":"Tests whether an index has the named property. Common index properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"Table 9.78. Index Properties\"\u003eTable 9.78\u003c/a\u003e. (Note that extension access methods can define additional property names for their indexes.) \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_zh":"测试一个索引是否具有指定名称的属性。表 9.78 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 NULL。","description_zh_html":"测试一个索引是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"表 9.78. 索引属性\"\u003e表 9.78\u003c/a\u003e 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Tests whether an index has the named property. Common index properties are listed in Table 9.78. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_html":"Tests whether an index has the named property. Common index properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"Table 9.78. Index Properties\"\u003eTable 9.78\u003c/a\u003e. (Note that extension access methods can define additional property names for their indexes.) \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_zh":"测试一个索引是否具有指定名称的属性。表 9.78 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 NULL。","description_zh_html":"测试一个索引是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"表 9.78. 索引属性\"\u003e表 9.78\u003c/a\u003e 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_index_has_property\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eindex\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eproperty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_index_has_property ( index regclass, property text ) → boolean","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-index-has-property","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_index_has_property","Summary":"Tests whether an index has the named property. Common index properties are listed in Table 9.78. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","BodyHTML":"Tests whether an index has the named property. Common index properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" rel=\"nofollow\"\u003eTable 9.78\u003c/a\u003e. (Note that extension access methods can define additional property names for their indexes.) \u003ccode\u003eNULL\u003c/code\u003e is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","SourceRevision":"wiki-repair-20261023:d06f09c88dab821aafb94bdaccfb0f3f301a68c1cb43f2f6a0bf7cda49907b43","ContentHash":"dd0e1ce08b0b5c10c88a5eaf305d0f5a0260c04c386ac700f84f66d2ccde4c27","Payload":{"description":"Tests whether an index has the named property. Common index properties are listed in Table 9.78. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_html":"Tests whether an index has the named property. Common index properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"Table 9.78. Index Properties\"\u003eTable 9.78\u003c/a\u003e. (Note that extension access methods can define additional property names for their indexes.) \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","signatures":[{"description":"Tests whether an index has the named property. Common index properties are listed in Table 9.78. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_html":"Tests whether an index has the named property. Common index properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"Table 9.78. Index Properties\"\u003eTable 9.78\u003c/a\u003e. (Note that extension access methods can define additional property names for their indexes.) \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_zh":"测试一个索引是否具有指定名称的属性。表 9.78 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 NULL。","description_zh_html":"测试一个索引是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"表 9.78. 索引属性\"\u003e表 9.78\u003c/a\u003e 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_index_has_property\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eindex\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eproperty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_index_has_property ( index regclass, property text ) → boolean","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"4d761c5af6e01fa104ae379a8e28e492620fc96e808a8e659cb4b73d2d8007bb","Text":"pg_index_has_property ( index regclass, property text ) → boolean","Returns":"boolean","Payload":{"description":"Tests whether an index has the named property. Common index properties are listed in Table 9.78. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_html":"Tests whether an index has the named property. Common index properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"Table 9.78. Index Properties\"\u003eTable 9.78\u003c/a\u003e. (Note that extension access methods can define additional property names for their indexes.) \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e is returned if the property name is not known or does not apply to the particular object, or if the OID does not identify a valid object.","description_zh":"测试一个索引是否具有指定名称的属性。表 9.78 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 NULL。","description_zh_html":"测试一个索引是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" title=\"表 9.78. 索引属性\"\u003e表 9.78\u003c/a\u003e 列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者 OID 不能识别有效的对象，则返回 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_index_has_property\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eindex\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eproperty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_index_has_property ( index regclass, property text ) → boolean","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}