{"Entry":{"collection":"func","key":"jsonb-path-exists","name":"jsonb_path_exists","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"11","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"12"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"17"}],"content_hash":"d73045ebe579e4ce83f165bfb79f340e76a7681e607a09fe272f2b1e7b35544c","first_version":"12","group":"json","group_label":"Json Functions And Operators","groups":["json"],"imported_at":"2026-09-14T21:49:48.805153+08:00","last_version":"20","name":"jsonb_path_exists","name_key":"jsonb_path_exists","position":16038,"present_in":["12","13","14","15","16","17","18","19","20"],"signature":"jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean","signature_count":1,"slug":"jsonb-path-exists","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"Checks whether the JSON path returns any item for the specified JSON value.","summary_zh":""}},"Definition":{"Collection":"func","Key":"jsonb-path-exists","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"jsonb-path-exists","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Checks whether the JSON path returns any item for the specified JSON value. (This is useful only with SQL-standard JSON path expressions, not predicate check expressions, since those always return a value.) If the vars argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the jsonpath expression. If the silent argument is specified and is true, the function suppresses the same errors as the @? and @@ operators do.","description_html":"Checks whether the JSON path returns any item for the specified JSON value. (This is useful only with SQL-standard JSON path expressions, not \u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" title=\"9.16.2.1.1. Boolean Predicate Check Expressions\"\u003epredicate check expressions\u003c/a\u003e, since those always return a value.) If the \u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the \u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e expression. If the \u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e argument is specified and is \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e, the function suppresses the same errors as the \u003ccode class=\"literal\"\u003e@?\u003c/code\u003e and \u003ccode class=\"literal\"\u003e@@\u003c/code\u003e operators do.","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":"Checks whether the JSON path returns any item for the specified JSON value. (This is useful only with SQL-standard JSON path expressions, not predicate check expressions, since those always return a value.) If the vars argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the jsonpath expression. If the silent argument is specified and is true, the function suppresses the same errors as the @? and @@ operators do.","description_html":"Checks whether the JSON path returns any item for the specified JSON value. (This is useful only with SQL-standard JSON path expressions, not \u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" title=\"9.16.2.1.1. Boolean Predicate Check Expressions\"\u003epredicate check expressions\u003c/a\u003e, since those always return a value.) If the \u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the \u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e expression. If the \u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e argument is specified and is \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e, the function suppresses the same errors as the \u003ccode class=\"literal\"\u003e@?\u003c/code\u003e and \u003ccode class=\"literal\"\u003e@@\u003c/code\u003e operators do.","description_zh":"","description_zh_html":"","examples":[{"expr":"jsonb_path_exists('{\"a\":[1,2,3,4,5]}', '$.a[*] ? (@ \u003e= $min \u0026\u0026 @ \u003c= $max)', '{\"min\":2, \"max\":4}')","result":"t"}],"html":"\u003ccode class=\"function\"\u003ejsonb_path_exists\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\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-JSON-PROCESSING-TABLE","file":"functions-json.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"jsonb-path-exists","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"jsonb_path_exists","Summary":"检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于谓词检查表达式，因为后者总是返回一个值。）如果指定了vars参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到jsonpath表达式中的具名值。如果指定了silent参数并为true，函数会抑制与@? 和 @@操作符相同的错误。","BodyHTML":"检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于\u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" rel=\"nofollow\"\u003e谓词检查表达式\u003c/a\u003e，因为后者总是返回一个值。）如果指定了\u003cem\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到\u003ccode\u003ejsonpath\u003c/code\u003e表达式中的具名值。如果指定了\u003cem\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e参数并为\u003ccode\u003etrue\u003c/code\u003e，函数会抑制与\u003ccode\u003e@?\u003c/code\u003e 和 \u003ccode\u003e@@\u003c/code\u003e操作符相同的错误。\u003cpre\u003ejsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean\u003c/pre\u003e检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于\u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" rel=\"nofollow\"\u003e谓词检查表达式\u003c/a\u003e，因为后者总是返回一个值。）如果指定了\u003cem\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到\u003ccode\u003ejsonpath\u003c/code\u003e表达式中的具名值。如果指定了\u003cem\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e参数并为\u003ccode\u003etrue\u003c/code\u003e，函数会抑制与\u003ccode\u003e@?\u003c/code\u003e 和 \u003ccode\u003e@@\u003c/code\u003e操作符相同的错误。","SourceRevision":"1b5ca64c","ContentHash":"fce95a87ffb16aba1474fb3a2b04d55d60d6400e4108c6ca82f979a53edceb53","Payload":{"description_zh":"检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于谓词检查表达式，因为后者总是返回一个值。）如果指定了vars参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到jsonpath表达式中的具名值。如果指定了silent参数并为true，函数会抑制与@? 和 @@操作符相同的错误。","description_zh_html":"检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于\u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" title=\"9.16.2.1.1. 布尔谓词检查表达式\"\u003e谓词检查表达式\u003c/a\u003e，因为后者总是返回一个值。）如果指定了\u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到\u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e表达式中的具名值。如果指定了\u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e参数并为\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e，函数会抑制与\u003ccode class=\"literal\"\u003e@?\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003e@@\u003c/code\u003e操作符相同的错误。","signatures":[{"description_zh":"检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于谓词检查表达式，因为后者总是返回一个值。）如果指定了vars参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到jsonpath表达式中的具名值。如果指定了silent参数并为true，函数会抑制与@? 和 @@操作符相同的错误。","description_zh_html":"检查 JSON 路径是否为指定的 JSON 值返回任何项。（这只对 SQL 标准 JSON 路径表达式有用，而不适用于\u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" title=\"9.16.2.1.1. 布尔谓词检查表达式\"\u003e谓词检查表达式\u003c/a\u003e，因为后者总是返回一个值。）如果指定了\u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e参数，则它必须是一个 JSON 对象，并且它的字段提供要替换到\u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e表达式中的具名值。如果指定了\u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e参数并为\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e，函数会抑制与\u003ccode class=\"literal\"\u003e@?\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003e@@\u003c/code\u003e操作符相同的错误。","returns":"boolean","text":"jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"fb84571b67061789825734c85b26dd134f8599ff674cb89b07719ec6dd1a6d50","Text":"jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean","Returns":"boolean","Payload":{"description":"Checks whether the JSON path returns any item for the specified JSON value. (This is useful only with SQL-standard JSON path expressions, not predicate check expressions, since those always return a value.) If the vars argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the jsonpath expression. If the silent argument is specified and is true, the function suppresses the same errors as the @? and @@ operators do.","description_html":"Checks whether the JSON path returns any item for the specified JSON value. (This is useful only with SQL-standard JSON path expressions, not \u003ca href=\"/docs/18/functions-json.html#FUNCTIONS-SQLJSON-CHECK-EXPRESSIONS\" title=\"9.16.2.1.1. Boolean Predicate Check Expressions\"\u003epredicate check expressions\u003c/a\u003e, since those always return a value.) If the \u003cem class=\"parameter\"\u003e\u003ccode\u003evars\u003c/code\u003e\u003c/em\u003e argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the \u003ccode class=\"type\"\u003ejsonpath\u003c/code\u003e expression. If the \u003cem class=\"parameter\"\u003e\u003ccode\u003esilent\u003c/code\u003e\u003c/em\u003e argument is specified and is \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e, the function suppresses the same errors as the \u003ccode class=\"literal\"\u003e@?\u003c/code\u003e and \u003ccode class=\"literal\"\u003e@@\u003c/code\u003e operators do.","description_zh":"","description_zh_html":"","examples":[{"expr":"jsonb_path_exists('{\"a\":[1,2,3,4,5]}', '$.a[*] ? (@ \u003e= $min \u0026\u0026 @ \u003c= $max)', '{\"min\":2, \"max\":4}')","result":"t"}],"html":"\u003ccode class=\"function\"\u003ejsonb_path_exists\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\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}