get_json_path() Returns Value it Should Not

Issue #1 resolved
David Wheeler created an issue

Consider:

david=# select json_get_path_as_text('{"foo": ["this", "that"]}'::json, 'bar', '1');
 json_get_path_as_text 
-----------------------
 that
(1 row)

Note that there is no {{bar}} key in that JSON. The same does not happen when fetching each part of the tree in sequence:

david=# select '{"foo": ["this", "that"]}'::json -> 'bar' -> 1;
 ?column? 
----------
 [null]

Comments (1)

  1. Log in to comment