{"Entry":{"collection":"operator","key":"op-7c7c-anyarray-anyarray","name":"||(anyarray,anyarray)","aliases":["||","||(anyarray,anyarray)"],"metadata":{"aliases":["||","||(anyarray,anyarray)"],"category":"Pseudo-types","content_hash":"3275028b51e0ba2998bfef3a0317651c5eb19848f3a27cc1cbe7955d461169ec","imported_at":"2026-09-30T00:40:43.763916+08:00","name":"||(anyarray,anyarray)","name_zh":"","slug":"op-7c7c-anyarray-anyarray","summary":"concatenate"}},"Definition":{"Collection":"operator","Key":"op-7c7c-anyarray-anyarray","SourceDatabase":"center","Version":"13","SourceTable":"pg_operator_entry","SourceKey":"op-7c7c-anyarray-anyarray","SourceRevision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","Facts":{"aliases":["||","||(anyarray,anyarray)"],"comparison_data":{"memberships":[],"operator":{"commutator":"","function":"array_cat(anyarray,anyarray)","hash_join":"f","kind":"b","left_type":"anyarray","merge_join":"f","negator":"","result_type":"anyarray","right_type":"anyarray","symbol":"||"}},"comparison_hash":"27d1b7b458b3c26700b553f076f91669ac2c7a8aed53794a86eed2380b2233a7","description":["concatenate"],"facts":[{"label":"Left operand","value":"anyarray"},{"label":"Right operand","value":"anyarray"},{"label":"Result type","value":"anyarray"},{"label":"Implementing function","value":"array_cat(anyarray,anyarray)"},{"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(anyarray,anyarray)","hash_join":"f","kind":"b","left_type":"anyarray","merge_join":"f","negator":"","result_type":"anyarray","right_type":"anyarray","symbol":"||"},"related":[{"label":"anyarray data type","url":"/wiki/type/anyarray/?v=13"}],"release":{"catalog_fingerprint":"df58d29b226fbb90326087233d7970032abdec1352373270449eeee324f84a35","channel":"historical","label":"13.23","major":"13","manual_fingerprint":"2bbea71f4723fc9e4e58cfdb28368763f999de2800d45ade748f7c7546dfb9d3","ref":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","revision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"},"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).","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]] → {{1,2,3},{4,5,6},{7,8,9}}"],"title":"English manual definition"},{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.14 for more information.","Unused columns contain zeroes. For example, oprleft is zero for a prefix operator."],"title":"Catalog interpretation"}],"signature":"||(anyarray,anyarray) → anyarray","source_oid":"375","sources":[{"label":"Matching PostgreSQL source archive","sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2"},{"label":"PostgreSQL 13 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"1a325d2fa41f711c0a7fa6b57e37e8e98a59f218e01112e0767c455c1b5818a1","url":"/docs/13/catalog-pg-operator.html"},{"label":"PostgreSQL 13 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"7a8e67f8dc59c305612c6d029fc8760c092f27203d5338c6db6c6d9b8aabc561","url":"/docs/13/catalog-pg-amop.html"},{"label":"PostgreSQL 13 English manual: functions-array.html","path":"functions-array.html","sha256":"e59b1b962a8068b4e7cd41addcb4f2f114f6dd84623b59249076c6d1c2036221","url":"/docs/13/functions-array.html#ARRAY-OPERATORS-TABLE"}],"tables":[]},"ManualEvidence":{"release":{"catalog_fingerprint":"df58d29b226fbb90326087233d7970032abdec1352373270449eeee324f84a35","channel":"historical","label":"13.23","major":"13","manual_fingerprint":"2bbea71f4723fc9e4e58cfdb28368763f999de2800d45ade748f7c7546dfb9d3","ref":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","revision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2"},{"label":"PostgreSQL 13 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"1a325d2fa41f711c0a7fa6b57e37e8e98a59f218e01112e0767c455c1b5818a1","url":"/docs/13/catalog-pg-operator.html"},{"label":"PostgreSQL 13 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"7a8e67f8dc59c305612c6d029fc8760c092f27203d5338c6db6c6d9b8aabc561","url":"/docs/13/catalog-pg-amop.html"},{"label":"PostgreSQL 13 English manual: functions-array.html","path":"functions-array.html","sha256":"e59b1b962a8068b4e7cd41addcb4f2f114f6dd84623b59249076c6d1c2036221","url":"/docs/13/functions-array.html#ARRAY-OPERATORS-TABLE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-7c7c-anyarray-anyarray","SourceDatabase":"center","Version":"13","Locale":"en","Title":"||(anyarray,anyarray)","Summary":"concatenate","BodyHTML":"\u003cp\u003econcatenate\u003c/p\u003e","SourceRevision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","ContentHash":"15b7fb03a6946fd546a269c866826ef735e264990e740cf09ad57067f87def6d","Payload":{"description":["concatenate"],"related":[{"label":"anyarray data type","url":"/wiki/type/anyarray/?v=13"}],"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).","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]] → {{1,2,3},{4,5,6},{7,8,9}}"],"title":"English manual definition"},{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.14 for more information.","Unused columns contain zeroes. For example, oprleft is zero for a prefix operator."],"title":"Catalog interpretation"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}