diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2024-06-17 10:31:29 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2024-06-17 10:31:29 -0400 |
| commit | 653d3969bb013f14c4a6884a253ad9676caf8166 (patch) | |
| tree | c12871a8d357b249f3a3ee8268883d2febcce932 /doc/src | |
| parent | 81d20fbf7a03f5e385700c90aec883c96b32ddc6 (diff) | |
| download | postgresql-653d3969bb013f14c4a6884a253ad9676caf8166.tar.gz postgresql-653d3969bb013f14c4a6884a253ad9676caf8166.zip | |
Teach jsonpath string() to unwrap in lax mode
This was an ommission in commit 66ea94e, and brings it into compliance
with both other methods and the standard.
Per complaint from David Wheeler.
Author: David Wheeler, Jeevan Chalke
Reviewed-by: Chapman Flack
Discussion: https://postgr.es/m/A64AE04F-4410-42B7-A141-7A7349260F4D@justatheory.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 17c44bc3384..2609269610b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -17792,7 +17792,10 @@ ERROR: jsonpath member accessor can only be applied to an object methods available in <type>jsonpath</type>. Note that while the unary operators and methods can be applied to multiple values resulting from a preceding path step, the binary operators (addition etc.) can only be - applied to single values. + applied to single values. In lax mode, methods applied to an array will be + executed for each value in the array. The exceptions are + <literal>.type()</literal> and <literal>.size()</literal>, which apply to + the array itself. </para> <table id="functions-sqljson-op-table"> |