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 /src/test/regress/sql/jsonb_jsonpath.sql | |
| 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 'src/test/regress/sql/jsonb_jsonpath.sql')
| -rw-r--r-- | src/test/regress/sql/jsonb_jsonpath.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/test/regress/sql/jsonb_jsonpath.sql b/src/test/regress/sql/jsonb_jsonpath.sql index cbd2db533d4..5e14f7759bb 100644 --- a/src/test/regress/sql/jsonb_jsonpath.sql +++ b/src/test/regress/sql/jsonb_jsonpath.sql @@ -586,6 +586,7 @@ select jsonb_path_query('"1.23aaa"', '$.string()'); select jsonb_path_query('1234', '$.string()'); select jsonb_path_query('true', '$.string()'); select jsonb_path_query('1234', '$.string().type()'); +select jsonb_path_query('[2, true]', '$.string()'); select jsonb_path_query('"2023-08-15 12:34:56 +5:30"', '$.timestamp().string()'); select jsonb_path_query_tz('"2023-08-15 12:34:56 +5:30"', '$.timestamp().string()'); -- should work select jsonb_path_query_array('[1.23, "yes", false]', '$[*].string()'); |