On Thu, Nov 23, 2023 at 6:46 PM jian he <jian.universal...@gmail.com> wrote: > > -----however these four will not fail. > SELECT JSON_QUERY(jsonb '{"a":[3,4]}', '$.z' RETURNING int4range empty > object on error); > SELECT JSON_QUERY(jsonb '{"a":[3,4]}', '$.z' RETURNING int4range empty > array on error); > SELECT JSON_QUERY(jsonb '{"a":[3,4]}', '$.z' RETURNING int4range empty > array on empty); > SELECT JSON_QUERY(jsonb '{"a":[3,4]}', '$.z' RETURNING int4range empty > object on empty); > > should the last four query fail or just return null?
I refactored making the above four queries fail. SELECT JSON_QUERY(jsonb '{"a":[3,4]}', '$.z' RETURNING int4range empty object on error); The new error is: ERROR: cannot cast DEFAULT expression of type jsonb to int4range. also make the following query fail, which is as expected, imho. select json_value(jsonb '{"a":[123.45,1]}', '$.z' returning text error on empty);
v1-0001-handle-key-words-empty-array-and-empty-object.nocfbot
Description: Binary data