{"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","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"],"signature":"pg_index_has_property ( index regclass, property text ) → boolean","signature_count":1,"slug":"pg-index-has-property","source_rev":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-index-has-property","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_index_has_property","Summary":"测试一个索引是否具有指定名称的属性。表 9.78列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID不能识别有效的对象，则返回NULL。","BodyHTML":"测试一个索引是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" rel=\"nofollow\"\u003e表 9.78\u003c/a\u003e列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID不能识别有效的对象，则返回\u003ccode\u003eNULL\u003c/code\u003e。\u003cpre\u003epg_index_has_property ( index regclass, property text ) → boolean\u003c/pre\u003e测试一个索引是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-PROPS\" rel=\"nofollow\"\u003e表 9.78\u003c/a\u003e列出了常用的索引属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID不能识别有效的对象，则返回\u003ccode\u003eNULL\u003c/code\u003e。","SourceRevision":"ca936764","ContentHash":"de93322ceb64b3189b9de62ba41eb13d925b3906fbbe6ddf0956d66d3e6ca066","Payload":{"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。","signatures":[{"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。","returns":"boolean","text":"pg_index_has_property ( index regclass, property text ) → boolean","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}