Commit77cdee9

committed

doc: Fix some issues with JSON_TABLE() exampls

1. Remove an unused PASSING variable. 2. Adjust formatting of JSON data used in an example to be valid under strict modeReported-by: Miłosz Chmura <mieszko4@gmail.com>Author: Robert Treat <rob@xzilla.net>Discussion:https://postgr.es/m/173859550337.1071.4748984213168572913@wrigleys.postgresql.org

1 parent7edd2cb commit77cdee9Copy full SHA for 77cdee9

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -19308,7 +19308,7 @@ SELECT jt.* FROM`
`19308`	`19308`	`SELECT jt.* FROM`
`19309`	`19309`	`my_films,`
`19310`	`19310`	`JSON_TABLE (js, '$.favorites[] ? (@.films[].director == $filter)'`
`19311`		`- PASSING 'Alfred Hitchcock' AS filter, 'Vertigo' AS filter2`
	`19311`	`+ PASSING 'Alfred Hitchcock' AS filter`
`19312`	`19312`	`COLUMNS (`
`19313`	`19313`	`id FOR ORDINALITY,`
`19314`	`19314`	`kind text PATH '$.kind',`
`@@ -19395,13 +19395,13 @@ SELECT jt.* FROM`
`19395`	`19395`	`<programlisting>`
`19396`	`19396`	`SELECT * FROM JSON_TABLE (`
`19397`	`19397`	`'{"favorites":`
`19398`		`- {"movies":`
	`19398`	`+[{"movies":`
`19399`	`19399`	`[{"name": "One", "director": "John Doe"},`
`19400`	`19400`	`{"name": "Two", "director": "Don Joe"}],`
`19401`	`19401`	`"books":`
`19402`	`19402`	`[{"name": "Mystery", "authors": [{"name": "Brown Dan"}]},`
`19403`	`19403`	`{"name": "Wonder", "authors": [{"name": "Jun Murakami"}, {"name":"Craig Doe"}]}]`
`19404`		`-}}'::json, '$.favorites[*]'`
	`19404`	`+}]}'::json, '$.favorites[*]'`
`19405`	`19405`	`COLUMNS (`
`19406`	`19406`	`user_id FOR ORDINALITY,`
`19407`	`19407`	`NESTED '$.movies[*]'`

Comments

(0)