Improve error reporting for jsonpath .double() method
authorAlexander Korotkov <akorotkov@postgresql.org>
Sat, 11 Jul 2020 00:20:46 +0000 (03:20 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Sat, 11 Jul 2020 00:20:46 +0000 (03:20 +0300)
commit0657181167467ec5cfb5a28aacf47ca02f5f4588
tree6dfd79c50bf090988294013f2b52b45bf365384b
parente91cd951b1114a009a0256f211a41d0ec873b2fc
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
src/backend/utils/adt/jsonpath_exec.c
src/test/regress/expected/jsonb_jsonpath.out
src/test/regress/sql/jsonb_jsonpath.sql