{"Entry":{"collection":"operator","key":"op-7c7c-anycompatiblearray-anycompatiblearray","name":"||(anycompatiblearray,anycompatiblearray)","aliases":["||","||(anycompatiblearray,anycompatiblearray)"],"metadata":{"aliases":["||","||(anycompatiblearray,anycompatiblearray)"],"category":"Pseudo-types","content_hash":"c78eb08ff402df4013a7743479ea23048ceda898496a8dad31e2a05648eb2156","derived_content_hash":"ceab827535d590b859b4fc5844c4c21d3d9494fefd2885e7a59faf655107a85a","imported_at":"2026-09-30T00:40:43.776144+08:00","name":"||(anycompatiblearray,anycompatiblearray)","name_zh":"","slug":"op-7c7c-anycompatiblearray-anycompatiblearray","summary":"concatenate"}},"Definition":{"Collection":"operator","Key":"op-7c7c-anycompatiblearray-anycompatiblearray","SourceDatabase":"center","Version":"18","SourceTable":"pg_operator_entry","SourceKey":"op-7c7c-anycompatiblearray-anycompatiblearray","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":["||","||(anycompatiblearray,anycompatiblearray)"],"comparison_data":{"memberships":[],"operator":{"commutator":"","function":"array_cat(anycompatiblearray,anycompatiblearray)","hash_join":"f","kind":"b","left_type":"anycompatiblearray","merge_join":"f","negator":"","result_type":"anycompatiblearray","right_type":"anycompatiblearray","symbol":"||"}},"comparison_hash":"bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a","description":["concatenate"],"description_zh":"连接。","description_zh_html":"\u003cp\u003e连接。\u003c/p\u003e\u003cdl\u003e\u003cdt\u003e种类\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eb\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e符号\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e||\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e实现函数\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003earray_cat(anycompatiblearray,anycompatiblearray)\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e可用于哈希连接\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e否\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e左操作数类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eanycompatiblearray\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e可用于归并连接\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e否\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e右操作数类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eanycompatiblearray\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e结果类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eanycompatiblearray\u003c/code\u003e\u003c/dd\u003e\u003c/dl\u003e\u003ch3\u003e同版本中文手册节选\u003c/h3\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 9.56. 数组操作符\u003c/strong\u003e\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e本页开头的中文说明为 PG.CENTER 对源码说明的翻译；手册节选保留对应版本中文文档原文。源码信息及手册示例不代表重新进行过运行测试。\u003c/p\u003e","facts":[{"label":"Left operand","value":"anycompatiblearray"},{"label":"Right operand","value":"anycompatiblearray"},{"label":"Result type","value":"anycompatiblearray"},{"label":"Implementing function","value":"array_cat(anycompatiblearray,anycompatiblearray)"},{"label":"Operator kind","value":"Binary"},{"label":"Hash join candidate","value":"no"},{"label":"Merge join candidate","value":"no"}],"facts_zh":[{"label":"左操作数","value":"anycompatiblearray"},{"label":"右操作数","value":"anycompatiblearray"},{"label":"返回类型","value":"anycompatiblearray"},{"label":"实现函数","value":"array_cat(anycompatiblearray,anycompatiblearray)"},{"label":"操作符种类","value":"Binary"},{"label":"可用于哈希连接","value":"否"},{"label":"可用于归并连接","value":"否"}],"manual_semantics":"Exact operand/result signature matched","memberships":[],"operator":{"commutator":"","function":"array_cat(anycompatiblearray,anycompatiblearray)","hash_join":"f","kind":"b","left_type":"anycompatiblearray","merge_join":"f","negator":"","result_type":"anycompatiblearray","right_type":"anycompatiblearray","symbol":"||"},"related":[{"label":"anycompatiblearray data type","url":"/wiki/type/anycompatiblearray/?v=18"}],"release":{"catalog_fingerprint":"deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6","channel":"stable","label":"18.6","major":"18","manual_fingerprint":"fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).","ARRAY[1,2,3] || ARRAY[4,5,6,7] → {1,2,3,4,5,6,7}","ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] → {{1,2,3},{4,5,6},{7,8,9.9}}"],"title":"English manual definition"},{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."],"title":"Catalog interpretation"}],"sections_zh":[{"paragraphs":["连接两个数组。连接 null 或空数组不会产生任何效果；否则，数组必须具有相同的维数（如第一个示例所示），或维数相差一维（如第二个示例所示）。如果数组的元素类型不同，则会将它们强制转换为同一个类型（参见 第 10.5 节 ）。","ARRAY[1,2,3] || ARRAY[4,5,6,7] → {1,2,3,4,5,6,7}","ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] → {{1,2,3},{4,5,6},{7,8,9.9}}"],"title":"英文手册定义"},{"paragraphs":["目录 pg_operator 存储关于操作符的信息。详见 CREATE OPERATOR 和 第 36.14 节 。"],"title":"目录记录解读"}],"signature":"||(anycompatiblearray,anycompatiblearray) → anycompatiblearray","source_oid":"375","sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","url":"/docs/18/catalog-pg-operator.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","url":"/docs/18/catalog-pg-amop.html"},{"label":"PostgreSQL 18 English manual: functions-array.html","path":"functions-array.html","sha256":"d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c","url":"/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}],"tables":[],"tables_zh":[],"zh_from":{"authored_translation":"authored-translation-of-source-description","body_sha256":"3e6f4b54fe91da9c7c776793c550b1bdd977460e16e96d50d0f047a45f62186e","kind":"same-version-chinese-manual-with-authored-translation-of-source-description","manual":{"anchor":"ARRAY-OPERATORS-TABLE","build_id":107,"extraction":"concept-introduction","fragment_sha256":"11833a0773d62a98775f804af42de3891fce6334c20ea10c046df39f619a0772","locale":"zh-Hans","page_key":"functions-array.html","source_hash":"a25a0710e8f84e027ef945e85452074399887341e22d79542584f9c646b8f076","source_revision":"unknown:rendered-translation-baseline","translated_from_revision":null,"translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}},"ManualEvidence":{"release":{"catalog_fingerprint":"deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6","channel":"stable","label":"18.6","major":"18","manual_fingerprint":"fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","url":"/docs/18/catalog-pg-operator.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","url":"/docs/18/catalog-pg-amop.html"},{"label":"PostgreSQL 18 English manual: functions-array.html","path":"functions-array.html","sha256":"d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c","url":"/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-7c7c-anycompatiblearray-anycompatiblearray","SourceDatabase":"center","Version":"18","Locale":"en","Title":"||(anycompatiblearray,anycompatiblearray)","Summary":"concatenate","BodyHTML":"\u003cp\u003econcatenate\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"d3e45a030f17378425a8a79974a4979ff7ebf2d0940773a49dfb4195594a2a33","Payload":{"description":["concatenate"],"related":[{"label":"anycompatiblearray data type","url":"/wiki/type/anycompatiblearray/?v=18"}],"sections":[{"paragraphs":["Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).","ARRAY[1,2,3] || ARRAY[4,5,6,7] → {1,2,3,4,5,6,7}","ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] → {{1,2,3},{4,5,6},{7,8,9.9}}"],"title":"English manual definition"},{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."],"title":"Catalog interpretation"}],"tables":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}