Commite7563e3

committed

doc: Fix some issues with JSON_TABLE() examples

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 parentac0e331 commite7563e3Copy full SHA for e7563e3

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -19475,7 +19475,7 @@ SELECT jt.* FROM`
`19475`	`19475`	`SELECT jt.* FROM`
`19476`	`19476`	`my_films,`
`19477`	`19477`	`JSON_TABLE (js, '$.favorites[] ? (@.films[].director == $filter)'`
`19478`		`- PASSING 'Alfred Hitchcock' AS filter, 'Vertigo' AS filter2`
	`19478`	`+ PASSING 'Alfred Hitchcock' AS filter`
`19479`	`19479`	`COLUMNS (`
`19480`	`19480`	`id FOR ORDINALITY,`
`19481`	`19481`	`kind text PATH '$.kind',`
`@@ -19562,13 +19562,13 @@ SELECT jt.* FROM`
`19562`	`19562`	`<programlisting>`
`19563`	`19563`	`SELECT * FROM JSON_TABLE (`
`19564`	`19564`	`'{"favorites":`
`19565`		`- {"movies":`
	`19565`	`+[{"movies":`
`19566`	`19566`	`[{"name": "One", "director": "John Doe"},`
`19567`	`19567`	`{"name": "Two", "director": "Don Joe"}],`
`19568`	`19568`	`"books":`
`19569`	`19569`	`[{"name": "Mystery", "authors": [{"name": "Brown Dan"}]},`
`19570`	`19570`	`{"name": "Wonder", "authors": [{"name": "Jun Murakami"}, {"name":"Craig Doe"}]}]`
`19571`		`-}}'::json, '$.favorites[*]'`
	`19571`	`+}]}'::json, '$.favorites[*]'`
`19572`	`19572`	`COLUMNS (`
`19573`	`19573`	`user_id FOR ORDINALITY,`
`19574`	`19574`	`NESTED '$.movies[*]'`

Comments

(0)