diff options
author | Peter Eisentraut <peter@eisentraut.org> | 2024-01-03 21:02:49 +0100 |
---|---|---|
committer | Peter Eisentraut <peter@eisentraut.org> | 2024-01-03 21:02:49 +0100 |
commit | 0958f8f6bf60639a1d22d78d5b49a6092b11833d (patch) | |
tree | c9a83ecaaf3df63bc8a787cf280c9895e12b3776 /doc/src | |
parent | 76ba8a8b631454ad06b6d4dd186ef2a739f0f7ce (diff) | |
download | postgresql-0958f8f6bf60639a1d22d78d5b49a6092b11833d.tar.gz postgresql-0958f8f6bf60639a1d22d78d5b49a6092b11833d.zip |
Revert "Reorganise jsonpath operators and methods"
This reverts commit 283a95da923605c1cc148155db2d865d0801b419.
The reordering of JsonPathItemType affects the binary on-disk
compatibility of the jsonpath type, so we must not change it. Revert
for now and consider.
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 8f2a2315d8e..cec21e42c05 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -17691,43 +17691,43 @@ strict $.**.HR <row> <entry role="func_table_entry"><para role="func_signature"> - <replaceable>number</replaceable> <literal>.</literal> <literal>abs()</literal> + <replaceable>number</replaceable> <literal>.</literal> <literal>ceiling()</literal> <returnvalue><replaceable>number</replaceable></returnvalue> </para> <para> - Absolute value of the given number + Nearest integer greater than or equal to the given number </para> <para> - <literal>jsonb_path_query('{"z": -0.3}', '$.z.abs()')</literal> - <returnvalue>0.3</returnvalue> + <literal>jsonb_path_query('{"h": 1.3}', '$.h.ceiling()')</literal> + <returnvalue>2</returnvalue> </para></entry> </row> <row> <entry role="func_table_entry"><para role="func_signature"> - <replaceable>number</replaceable> <literal>.</literal> <literal>ceiling()</literal> + <replaceable>number</replaceable> <literal>.</literal> <literal>floor()</literal> <returnvalue><replaceable>number</replaceable></returnvalue> </para> <para> - Nearest integer greater than or equal to the given number + Nearest integer less than or equal to the given number </para> <para> - <literal>jsonb_path_query('{"h": 1.3}', '$.h.ceiling()')</literal> - <returnvalue>2</returnvalue> + <literal>jsonb_path_query('{"h": 1.7}', '$.h.floor()')</literal> + <returnvalue>1</returnvalue> </para></entry> </row> <row> <entry role="func_table_entry"><para role="func_signature"> - <replaceable>number</replaceable> <literal>.</literal> <literal>floor()</literal> + <replaceable>number</replaceable> <literal>.</literal> <literal>abs()</literal> <returnvalue><replaceable>number</replaceable></returnvalue> </para> <para> - Nearest integer less than or equal to the given number + Absolute value of the given number </para> <para> - <literal>jsonb_path_query('{"h": 1.7}', '$.h.floor()')</literal> - <returnvalue>1</returnvalue> + <literal>jsonb_path_query('{"z": -0.3}', '$.z.abs()')</literal> + <returnvalue>0.3</returnvalue> </para></entry> </row> |