pgsql: Improve error reporting for jsonpath .double() method

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема pgsql: Improve error reporting for jsonpath .double() method
Дата
Msg-id E1ju3Km-00015D-V3@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Improve error reporting for jsonpath .double() method

When jsonpath .double() method detects that numeric or string can't be
converted to double precision, it throws an error.  This commit makes these
errors explicitly express the reason of failure.

Discussion: https://postgr.es/m/CAPpHfdtqJtiSXkP7tOXez18NxhLUH_-75bL8%3DOce4Ki%2Bbv7V6Q%40mail.gmail.com
Author: Alexander Korotkov
Reviewed-by: Tom Lane
Backpatch-through: 12

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3ec5f6b53dfb6acfe66a952edef1b6887da91777

Modified Files
--------------
src/backend/utils/adt/jsonpath_exec.c        | 4 ++--
src/test/regress/expected/jsonb_jsonpath.out | 8 +++++---
src/test/regress/sql/jsonb_jsonpath.sql      | 1 +
3 files changed, 8 insertions(+), 5 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: pgsql: Forbid numeric NaN in jsonpath
Следующее
От: Michael Paquier
Дата:
Сообщение: pgsql: Rename field "relkind" to "objtype" for CTAS and ALTER TABLE nod