Re: Extract numeric filed in JSONB more effectively
От | jian he |
---|---|
Тема | Re: Extract numeric filed in JSONB more effectively |
Дата | |
Msg-id | CACJufxHdDkdR13nkhxybOUDKSB9kgsDhZU8xiGg1t_rVP-==nA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Extract numeric filed in JSONB more effectively (Andy Fan <zhihui.fan1213@gmail.com>) |
Ответы |
Re: Extract numeric filed in JSONB more effectively
|
Список | pgsql-hackers |
I think the last patch failed. I am not 100% sure. https://cirrus-ci.com/task/5464366154252288 says "Created 21 hours ago", I assume the latest patch. the diff in Artifacts section. you can go to testrun/build/testrun/regress/regress/regression.diffs diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out --- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2023-09-01 03:34:43.585036700 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2023-09-01 03:39:05.800452844 +0000 @@ -528,7 +528,7 @@ (3 rows) SELECT (test_json -> 'field1')::int4 FROM test_jsonb WHERE json_type = 'object'; -ERROR: cannot cast jsonb string to type integer +ERROR: unknown jsonb type: 1125096840 SELECT (test_json -> 'field1')::bool FROM test_jsonb WHERE json_type = 'object'; ERROR: cannot cast jsonb string to type boolean \pset null ''
В списке pgsql-hackers по дате отправления: