diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7efc81936a..c42ac559ee 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -19378,6 +19378,8 @@ where json_table_column is: The optional json_path_name serves as an identifier of the provided path_expression. + Note this identifier is not accesible at the SQL level, but will be + visible in EXPLAIN VERBOSE output. The name must be unique and distinct from the column names. @@ -19470,7 +19472,7 @@ SELECT jt.* FROM SELECT jt.* FROM my_films, JSON_TABLE (js, '$.favorites[*] ? (@.films[*].director == $filter)' - PASSING 'Alfred Hitchcock' AS filter, 'Vertigo' AS filter2 + PASSING 'Alfred Hitchcock' AS filter COLUMNS ( id FOR ORDINALITY, kind text PATH '$.kind', @@ -19557,13 +19559,13 @@ SELECT jt.* FROM SELECT * FROM JSON_TABLE ( '{"favorites": - {"movies": + [{"movies": [{"name": "One", "director": "John Doe"}, {"name": "Two", "director": "Don Joe"}], "books": [{"name": "Mystery", "authors": [{"name": "Brown Dan"}]}, {"name": "Wonder", "authors": [{"name": "Jun Murakami"}, {"name":"Craig Doe"}]}] -}}'::json, '$.favorites[*]' +}]}'::json, '$.favorites[*]' COLUMNS ( user_id FOR ORDINALITY, NESTED '$.movies[*]'