{"Entry":{"collection":"func","key":"pg-index-column-has-property","name":"pg_index_column_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":"937274c62ca8db6f3b85f3a302d1803e18bde12e40018c760b50a19e65b98c3a","first_version":"9.6","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.244746+08:00","last_version":"20","name":"pg_index_column_has_property","name_key":"pg_index_column_has_property","position":28081,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_index_column_has_property ( index regclass, column integer, property text ) → boolean","signature_count":1,"slug":"pg-index-column-has-property","source_rev":"b7bd9cda","summary":"Tests whether an index column has the named property.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-index-column-has-property","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-index-column-has-property","SourceRevision":"b7bd9cda","Facts":{"description":"Tests whether an index column has the named property. Common index column properties are listed in Table 9.77. (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 or column number does not identify a valid object.","description_html":"Tests whether an index column has the named property. Common index column properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" title=\"Table 9.77. Index Column Properties\"\u003eTable 9.77\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 or column number 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 column has the named property. Common index column properties are listed in Table 9.77. (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 or column number does not identify a valid object.","description_html":"Tests whether an index column has the named property. Common index column properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" title=\"Table 9.77. Index Column Properties\"\u003eTable 9.77\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 or column number does not identify a valid object.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_index_column_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\u003ecolumn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\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_column_has_property ( index regclass, column integer, 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-column-has-property","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_index_column_has_property","Summary":"测试一个索引列是否具有指定名称的属性。表 9.77列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回NULL。","BodyHTML":"测试一个索引列是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" rel=\"nofollow\"\u003e表 9.77\u003c/a\u003e列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回\u003ccode\u003eNULL\u003c/code\u003e。\u003cpre\u003epg_index_column_has_property ( index regclass, column integer, property text ) → boolean\u003c/pre\u003e测试一个索引列是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" rel=\"nofollow\"\u003e表 9.77\u003c/a\u003e列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回\u003ccode\u003eNULL\u003c/code\u003e。","SourceRevision":"ca936764","ContentHash":"97f5640a04a0c79e8560315a428d318f112363435c99ac99cb36def1e90438c1","Payload":{"description_zh":"测试一个索引列是否具有指定名称的属性。表 9.77列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回NULL。","description_zh_html":"测试一个索引列是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" title=\"表 9.77. 索引列属性\"\u003e表 9.77\u003c/a\u003e列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回\u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","signatures":[{"description_zh":"测试一个索引列是否具有指定名称的属性。表 9.77列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回NULL。","description_zh_html":"测试一个索引列是否具有指定名称的属性。\u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" title=\"表 9.77. 索引列属性\"\u003e表 9.77\u003c/a\u003e列出了常用索引列属性。（注意，扩展访问方法可以为其索引定义额外的属性名。）如果属性名未知或不适用于特定对象，或者OID或列号不能识别有效的对象，则返回\u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","returns":"boolean","text":"pg_index_column_has_property ( index regclass, column integer, 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":"753fce83a863d40ceb86d3d6dfcc3bfe3a8cbb0064ff710683bf455afb27f959","Text":"pg_index_column_has_property ( index regclass, column integer, property text ) → boolean","Returns":"boolean","Payload":{"description":"Tests whether an index column has the named property. Common index column properties are listed in Table 9.77. (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 or column number does not identify a valid object.","description_html":"Tests whether an index column has the named property. Common index column properties are listed in \u003ca href=\"/docs/18/functions-info.html#FUNCTIONS-INFO-INDEX-COLUMN-PROPS\" title=\"Table 9.77. Index Column Properties\"\u003eTable 9.77\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 or column number does not identify a valid object.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_index_column_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\u003ecolumn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\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_column_has_property ( index regclass, column integer, property text ) → boolean","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}