BUG #15242: JSON functions not recognizing JSON

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15242: JSON functions not recognizing JSON
Дата
Msg-id 152899864499.24805.18088125700685635313@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15242: JSON functions not recognizing JSON
Re: BUG #15242: JSON functions not recognizing JSON
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15242
Logged by:          David
Email address:      david@daily-harvest.com
PostgreSQL version: 9.6.6
Operating system:   Mac / DBeaver
Description:

I get this error:   SQL Error [22023]: ERROR: cannot deconstruct an array as
an object

when running the statement below because the JSON_EACH function doesn't
recognize the JSON. If I remove the json_each function the query runs fine
and executes JSON_ARRAY_LENGTH on the same variable, even though both
functions take json.

WITH sample_text AS 
(
SELECT TEXT '[{"id":11,"name":"Chocolate +
Blueberry","sku":"11-CHOBLU"},{"id":11,"name":"Chocolate +
Blueberry","sku":"11-CHOBLU"}]' AS txt
)
SELECT json_array_length(txt::json), json_each(txt::json) FROM sample_text


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