{"Entry":{"collection":"operator","key":"op-7c7c-anycompatiblearray-anycompatiblearray","name":"||(anycompatiblearray,anycompatiblearray)","aliases":["||","||(anycompatiblearray,anycompatiblearray)"],"metadata":{"aliases":["||","||(anycompatiblearray,anycompatiblearray)"],"category":"Pseudo-types","content_hash":"c78eb08ff402df4013a7743479ea23048ceda898496a8dad31e2a05648eb2156","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"],"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"}],"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"}],"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":[]},"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":"zh-Hans","Fallback":true,"Versions":["14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}