{"Entry":{"collection":"func","key":"trim-array","name":"trim_array","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"14"}],"content_hash":"b68468c7ec9d37d4b30dd7c2fc567ae7e66adea1a417f356f0cb6a2aad2ea412","derived_content_hash":"2328a33ca355bbdcf31ad06ebe0f55a5c3c53eaae914b31b3f73cb8b90debbde","first_version":"14","group":"array","group_label":"Array Functions And Operators","groups":["array"],"imported_at":"2026-09-14T21:49:48.838622+08:00","last_version":"20","name":"trim_array","name_key":"trim_array","position":19019,"present_in":["14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"b44bfe8bafe61052fc6964f44b399792fea693e1ebceb5139918c2d5c9bf416e","repair":"wiki-repair-20261023"},"signature":"trim_array ( array anyarray, n integer ) → anyarray","signature_count":1,"slug":"trim-array","source_rev":"wiki-repair-20261023:d2fa7688eb0d8705028d85e56618ac19f391cb00e267c3752ba4366a7b9753f3","summary":"Trims an array by removing the last n elements.","summary_zh":""}},"Definition":{"Collection":"func","Key":"trim-array","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"trim-array","SourceRevision":"wiki-repair-20261023:d2fa7688eb0d8705028d85e56618ac19f391cb00e267c3752ba4366a7b9753f3","Facts":{"description":"Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.","description_html":"Trims an array by removing the last \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e elements. If the array is multidimensional, only the first dimension is trimmed.","description_zh":"通过删除最后的 n 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","description_zh_html":"通过删除最后的 \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","doc":{"anchor":"ARRAY-FUNCTIONS-TABLE","file":"functions-array.html","slug":"18"},"group":"array","group_label":"Array Functions And Operators","lang":"en","layout":"table-new","pages":["functions-array.html"],"prose_only":false,"signatures":[{"description":"Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.","description_html":"Trims an array by removing the last \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e elements. If the array is multidimensional, only the first dimension is trimmed.","description_zh":"通过删除最后的 n 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","description_zh_html":"通过删除最后的 \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","examples":[{"expr":"trim_array(ARRAY[1,2,3,4,5,6], 2)","result":"{1,2,3,4}"}],"html":"\u003ccode class=\"function\"\u003etrim_array\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003earray\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyarray\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyarray\u003c/code\u003e","returns":"anyarray","text":"trim_array ( array anyarray, n integer ) → anyarray","zh_from":"same-version-pgdoc"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-array.html","sha256":"a25a0710e8f84e027ef945e85452074399887341e22d79542584f9c646b8f076"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"ARRAY-FUNCTIONS-TABLE","file":"functions-array.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"trim-array","SourceDatabase":"center","Version":"18","Locale":"en","Title":"trim_array","Summary":"Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.","BodyHTML":"Trims an array by removing the last \u003cem\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e elements. If the array is multidimensional, only the first dimension is trimmed.","SourceRevision":"wiki-repair-20261023:d2fa7688eb0d8705028d85e56618ac19f391cb00e267c3752ba4366a7b9753f3","ContentHash":"5d0295333f200fda28c3e7a842fec4c88e0fdc650fb9fd9a167aaf81b924e150","Payload":{"description":"Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.","description_html":"Trims an array by removing the last \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e elements. If the array is multidimensional, only the first dimension is trimmed.","signatures":[{"description":"Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.","description_html":"Trims an array by removing the last \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e elements. If the array is multidimensional, only the first dimension is trimmed.","description_zh":"通过删除最后的 n 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","description_zh_html":"通过删除最后的 \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","examples":[{"expr":"trim_array(ARRAY[1,2,3,4,5,6], 2)","result":"{1,2,3,4}"}],"html":"\u003ccode class=\"function\"\u003etrim_array\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003earray\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyarray\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyarray\u003c/code\u003e","returns":"anyarray","text":"trim_array ( array anyarray, n integer ) → anyarray","zh_from":"same-version-pgdoc"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"50d0627bd5d6edcb14e3d67bad17d12b7b6fe8fc37c38217d3b1423b92be6b87","Text":"trim_array ( array anyarray, n integer ) → anyarray","Returns":"anyarray","Payload":{"description":"Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.","description_html":"Trims an array by removing the last \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e elements. If the array is multidimensional, only the first dimension is trimmed.","description_zh":"通过删除最后的 n 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","description_zh_html":"通过删除最后的 \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e 个元素来裁剪数组。如果数组是多维的，则只裁剪第一个维度。","examples":[{"expr":"trim_array(ARRAY[1,2,3,4,5,6], 2)","result":"{1,2,3,4}"}],"html":"\u003ccode class=\"function\"\u003etrim_array\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003earray\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyarray\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eanyarray\u003c/code\u003e","returns":"anyarray","text":"trim_array ( array anyarray, n integer ) → anyarray","zh_from":"same-version-pgdoc"}}],"Spellings":null,"SQLState":null,"Evidence":null}