{"Entry":{"collection":"func","key":"jsonb-path-query-array-tz","name":"jsonb_path_query_array_tz","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"13"}],"content_hash":"20d3f9ee1537ccdbe89f3d731cc8215e9613c1ea0661840862a6f5e3cf9aac80","first_version":"13","group":"json","group_label":"Json Functions And Operators","groups":["json"],"imported_at":"2026-09-14T21:49:48.808862+08:00","last_version":"20","name":"jsonb_path_query_array_tz","name_key":"jsonb_path_query_array_tz","position":16044,"present_in":["13","14","15","16","17","18","19","20"],"signature":"jsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb","signature_count":1,"slug":"jsonb-path-query-array-tz","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions.","summary_zh":""}},"Definition":{"Collection":"func","Key":"jsonb-path-query-array-tz","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"jsonb-path-query-array-tz","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions. The example below requires interpretation of the date-only value 2015-08-02 as a timestamp with time zone, so the result depends on the current TimeZone setting. Due to this dependency, these functions are marked as stable, which means these functions cannot be used in indexes. Their counterparts are immutable, and so can be used in indexes; but they will throw errors if asked to make such comparisons.","description_html":"These functions act like their counterparts described above without the \u003ccode class=\"literal\"\u003e_tz\u003c/code\u003e suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions. The example below requires interpretation of the date-only value \u003ccode class=\"literal\"\u003e2015-08-02\u003c/code\u003e as a timestamp with time zone, so the result depends on the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting. Due to this dependency, these functions are marked as stable, which means these functions cannot be used in indexes. Their counterparts are immutable, and so can be used in indexes; but they will throw errors if asked to make such comparisons.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-JSON-PROCESSING-TABLE","file":"functions-json.html","slug":"18"},"group":"json","group_label":"Json Functions And Operators","lang":"en","layout":"table-new","pages":["functions-json.html"],"prose_only":false,"signatures":[{"description":"These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions. The example below requires interpretation of the date-only value 2015-08-02 as a timestamp with time zone, so the result depends on the current TimeZone setting. Due to this dependency, these functions are marked as stable, which means these functions cannot be used in indexes. Their counterparts are immutable, and so can be used in indexes; but they will throw errors if asked to make such comparisons.","description_html":"These functions act like their counterparts described above without the \u003ccode class=\"literal\"\u003e_tz\u003c/code\u003e suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions. The example below requires interpretation of the date-only value \u003ccode class=\"literal\"\u003e2015-08-02\u003c/code\u003e as a timestamp with time zone, so the result depends on the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting. Due to this dependency, these functions are marked as stable, which means these functions cannot be used in indexes. Their counterparts are immutable, and so can be used in indexes; but they will throw errors if asked to make such comparisons.","description_zh":"","description_zh_html":"","examples":[{"expr":"jsonb_path_exists_tz('[\"2015-08-01 12:00:00-05\"]', '$[*] ? (@.datetime() \u003c \"2015-08-02\".datetime())')","result":"t"}],"html":"\u003ccode class=\"function\"\u003ejsonb_path_query_array_tz\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etarget\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejsonb\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epath\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejsonb\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e ]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003ejsonb\u003c/code\u003e","returns":"jsonb","text":"jsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-JSON-PROCESSING-TABLE","file":"functions-json.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"jsonb-path-query-array-tz","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"jsonb_path_query_array_tz","Summary":"这些函数的作用类似于上面描述的没有_tz后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值2015-08-02解释为带有时区的时间戳，因此结果取决于当前的TimeZone设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。","BodyHTML":"这些函数的作用类似于上面描述的没有\u003ccode\u003e_tz\u003c/code\u003e后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值\u003ccode\u003e2015-08-02\u003c/code\u003e解释为带有时区的时间戳，因此结果取决于当前的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\" rel=\"nofollow\"\u003eTimeZone\u003c/a\u003e设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。\u003cpre\u003ejsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb\u003c/pre\u003e这些函数的作用类似于上面描述的没有\u003ccode\u003e_tz\u003c/code\u003e后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值\u003ccode\u003e2015-08-02\u003c/code\u003e解释为带有时区的时间戳，因此结果取决于当前的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\" rel=\"nofollow\"\u003eTimeZone\u003c/a\u003e设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。","SourceRevision":"1b5ca64c","ContentHash":"524a529ec064050e9bde88c3e2400694524d4ec1800443dba70841a984c18188","Payload":{"description_zh":"这些函数的作用类似于上面描述的没有_tz后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值2015-08-02解释为带有时区的时间戳，因此结果取决于当前的TimeZone设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。","description_zh_html":"这些函数的作用类似于上面描述的没有\u003ccode class=\"literal\"\u003e_tz\u003c/code\u003e后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值\u003ccode class=\"literal\"\u003e2015-08-02\u003c/code\u003e解释为带有时区的时间戳，因此结果取决于当前的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。","signatures":[{"description_zh":"这些函数的作用类似于上面描述的没有_tz后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值2015-08-02解释为带有时区的时间戳，因此结果取决于当前的TimeZone设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。","description_zh_html":"这些函数的作用类似于上面描述的没有\u003ccode class=\"literal\"\u003e_tz\u003c/code\u003e后缀的对应函数，不同之处在于这些函数支持需要时区感知转换的日期/时间值的比较。下面的示例需要将仅日期值\u003ccode class=\"literal\"\u003e2015-08-02\u003c/code\u003e解释为带有时区的时间戳，因此结果取决于当前的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e设置。由于这种依赖性，这些函数被标记为稳定的，这意味着这些函数不能用于索引。它们的对应函数是不可变的，因此可以用于索引；但如果要求进行这样的比较，它们将抛出错误。","returns":"jsonb","text":"jsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"95d5fadd0dce6b37e8af196628da310e2d7740e1b3dbd96a7340b133688ec2de","Text":"jsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb","Returns":"jsonb","Payload":{"description":"These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions. The example below requires interpretation of the date-only value 2015-08-02 as a timestamp with time zone, so the result depends on the current TimeZone setting. Due to this dependency, these functions are marked as stable, which means these functions cannot be used in indexes. Their counterparts are immutable, and so can be used in indexes; but they will throw errors if asked to make such comparisons.","description_html":"These functions act like their counterparts described above without the \u003ccode class=\"literal\"\u003e_tz\u003c/code\u003e suffix, except that these functions support comparisons of date/time values that require timezone-aware conversions. The example below requires interpretation of the date-only value \u003ccode class=\"literal\"\u003e2015-08-02\u003c/code\u003e as a timestamp with time zone, so the result depends on the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting. Due to this dependency, these functions are marked as stable, which means these functions cannot be used in indexes. Their counterparts are immutable, and so can be used in indexes; but they will throw errors if asked to make such comparisons.","description_zh":"","description_zh_html":"","examples":[{"expr":"jsonb_path_exists_tz('[\"2015-08-01 12:00:00-05\"]', '$[*] ? (@.datetime() \u003c \"2015-08-02\".datetime())')","result":"t"}],"html":"\u003ccode class=\"function\"\u003ejsonb_path_query_array_tz\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etarget\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejsonb\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epath\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejsonb\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\u003c/span\u003e ]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003ejsonb\u003c/code\u003e","returns":"jsonb","text":"jsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}