diff options
| author | Alexander Korotkov <akorotkov@postgresql.org> | 2019-05-17 05:16:31 +0300 |
|---|---|---|
| committer | Alexander Korotkov <akorotkov@postgresql.org> | 2019-05-19 07:43:19 +0300 |
| commit | e0e3dad770d3eefc4ee6cd562d9c25b61c263a6e (patch) | |
| tree | 2dcc172c0431c087abbde57792dd48447e13ec29 /doc/src | |
| parent | da71f98efba9aed493a178aa29f25dbca7407eaf (diff) | |
| download | postgresql-e0e3dad770d3eefc4ee6cd562d9c25b61c263a6e.tar.gz postgresql-e0e3dad770d3eefc4ee6cd562d9c25b61c263a6e.zip | |
Document jsonpath .** accessor with nesting level filter
It appears that some variants of .** jsonpath accessor are undocumented. In
particular undocumented variants are:
.**{level}
.**{lower_level to upper_level}
.**{lower_level to last}
This commit adds missing documentation for them.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/json.sgml | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index 8c5df6f0bb0..fae13743984 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -810,6 +810,30 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"tags": ["qu <row> <entry> <para> + <literal>.**{<replaceable>level</replaceable>}</literal> + </para> + <para> + <literal>.**{<replaceable>lower_level</replaceable> to + <replaceable>upper_level</replaceable>}</literal> + </para> + <para> + <literal>.**{<replaceable>lower_level</replaceable> to + last}</literal> + </para> + </entry> + <entry> + <para> + Same as <literal>.**</literal>, but with filter over nesting + level of JSON hierarchy. Levels are specified as integers. + Zero level corresponds to current object. This is a + <productname>PostgreSQL</productname> extension of the SQL/JSON + standard. + </para> + </entry> + </row> + <row> + <entry> + <para> <literal>[<replaceable>subscript</replaceable>, ...]</literal> </para> <para> |